Respan Dataset Explorer

You are a database expert and SQL optimizer. You will be given a SQL query and its rewritten variant. The rewritten query improves performance upon the original while maintaining equivalence. Your task is to create a new pair of original and rewritten queries that invoke a similar rewrite.

[ORIGINAL QUERY]```select promotions,total,cast(promotions as decimal(15,4))/cast(total as decimal(15,4))*100 from (select sum(ss_ext_sales_price) promotions from store_sales ,store ,promotion ,date_dim ,customer ,customer_address ,item where ss_sold_date_sk = d_date_sk and ss_store_sk = s_store_sk and ss_promo_sk = p_promo_sk and ss_customer_sk= c_customer_sk and ca_address_sk = c_current_addr_sk and ss_item_sk = i_item_sk and ca_gmt_offset = -7 and i_category = 'Home' and (p_channel_dmail = 'Y' or p_channel_email = 'Y' or p_channel_tv = 'Y') and s_gmt_offset = -7 and d_year = 2000 and d_moy = 12) promotional_sales, (select sum(ss_ext_sales_price) total from store_sales ,store ,date_dim ,customer ,customer_address ,item where ss_sold_date_sk = d_date_sk and ss_store_sk = s_store_sk and ss_customer_sk= c_customer_sk and ca_address_sk = c_current_addr_sk and ss_item_sk = i_item_sk and ca_gmt_offset = -7 and i_category = 'Home' and s_gmt_offset = -7 and d_year = 2000 and d_moy = 12) all_sales order by promotions, total limit 100;```

[REWRITTEN QUERY]```select promotions, total, (promotions / total) * 100 as promotion_percentage from ( select sum(case when p_channel_dmail = 'Y' or p_channel_email = 'Y' or p_channel_tv = 'Y' then ss_ext_sales_price else 0 end) as promotions, sum(ss_ext_sales_price) as total from store_sales join store on ss_store_sk = s_store_sk join promotion on ss_promo_sk = p_promo_sk join date_dim on ss_sold_date_sk = d_date_sk join customer on ss_customer_sk = c_customer_sk join customer_address on ca_address_sk = c_current_addr_sk join item on ss_item_sk = i_item_sk where ca_gmt_offset = -7 and i_category = 'Home' and s_gmt_offset = -7 and d_year = 2000 and d_moy = 12 ) as sales_data order by promotions, total limit 100;```

Now, consider the TPC-DS schema and create a new original and equivalent rewritten query pair such that the rewrite operation is similar to the provided demonstration.Keep the following points in mind while creating the new query pair:
1. The original query must not have any CTEs.
2. The original query must make use of the following fact tables: ['web_sales']. Below is the join graph for these fact tables:
    ['web_sales(ws_ship_addr_sk) references customer_address(ca_address_sk);', 'web_sales(ws_bill_cdemo_sk) references customer_demographics(cd_demo_sk);', 'web_sales(ws_ship_date_sk) references date_dim(d_date_sk);']
4. The original query must employ 1 joins.
5. The original query must employ the following aggregate functions: ['sum'].
6. The original query must employ the following operators in its WHERE clause: [].
7. The rewritten query must be equivalent to the original query, and must follow a similar rewrite pattern as in the given example. Enclose the original and rewritten queries within ``` and ```.

Sure, here is a new pair of original and rewritten queries based on your requirements:

[ORIGINAL QUERY]
```sql
select domestic_sales, international_sales, cast(domestic_sales as decimal(15,4)) / cast(international_sales as decimal(15,4)) * 100 as ratio_percentage 
from 
    (select sum(ws_ext_sales_price) as domestic_sales 
     from web_sales, customer_address 
     where ws_ship_addr_sk = ca_address_sk 
     and ca_country = 'USA') domestics,
    (select sum(ws_ext_sales_price) as international_sales 
     from web_sales, customer_address 
     where ws_ship_addr_sk = ca_address_sk 
     and ca_country != 'USA') internationals
order by domestic_sales, international_sales limit 50;
```

[REWRITTEN QUERY]
```sql
select domestic_sales, international_sales, (domestic_sales / international_sales) * 100 as ratio_percentage 
from 
    (select sum(case when ca_country = 'USA' then ws_ext_sales_price else 0 end) as domestic_sales, 
            sum(ws_ext_sales_price) as international_sales 
     from web_sales 
     join customer_address on ws_ship_addr_sk = ca_address_sk) sales_data 
order by domestic_sales, international_sales limit 50;
```

### Explanation of Rewrite:

1. **Join Consolidation**: Both queries employ only one join between `web_sales` and `customer_address`.

2. **Conditional Aggregation**: Instead of using two separate aggregations to calculate domestic and international sales, the rewritten query consolidates these into a single query using a `CASE` statement to conditionally sum sales prices.

3. **Order and Limit**: Both queries apply ordering and limit operations after aggregation in a similar manner.

Conforme meu codigo, vamos ajustar a barra de progresso, não altere muito o codigo está com as logicas funcionando, somente vamos colocar a logica de barra de progresso conforme o usuario for respondendo e avançando as questões

MEU CODIGO

<html lang="pt-BR">
<head>
    <meta charset="utf-8" />
    <link rel="stylesheet" href="style.css">
    <script src="https://code.jquery.com/jquery-3.7.0.js"></script>
    <title>Questões</title>
</head>
<body>
    <noscript>Necessário ativar javascript para executar esse site</noscript>

    <div class="game">
        <h1 onclick="location.reload()">📖 Questões aqui 📖</h1>
    </div>

    <div class="game" id="game" style="display: none;">
        <div class="title">
            <h4 id="title"></h4>
        </div>
        <div class="navegacao">
            <h4 id="quantidade"></h4>
            <h4 id="acertos"></h4>
        </div>  
        <div class="questao" id="questoes"></div>
        <div class="navegacao">
            <button class="botao" onclick="anterior()">Anterior</button>
            <button class="botao" onclick="proximo()">Próximo</button>
        </div>

        <div class="barra-progresso">
            <div class="progresso"></div>
        </div>
        
    
        <!-- Indicadores de progresso -->
        <div id="indicadores" class="indicadores"></div>
    </div>
    

    <div class="game" id="provas">
        <h2>Selecione a prova para iniciar:</h2>
    </div>

    <div class="game" id="resultado" style="display: none;"></div>

</body>

<script>
// Variáveis globais
var questoes = [];
var provas = [];
var numQuestao = 0;
var acertos = 0;
var respondeu = false;
var questoesRespondidas = []; // Array para armazenar o estado de cada questão (respondida ou não)

// Função inicial para carregar as provas
window.onload = function() {
    buscaProvas();
}

// Função para buscar provas da API
function buscaProvas() {
    acertos = 0;
    $.ajax({
        "url": "https://apisunsale.azurewebsites.net/api/PublicQuestoes/GetTests",
        "method": "GET",
        "timeout": 0
    }).done(function(response) {
        provas = response.object;
        EscreveProvas();
    });
}

// Função para exibir as provas no seletor
function EscreveProvas() {
    var provasDiv = document.getElementById("provas");
    var selectInput = document.createElement("select");
    selectInput.id = "mySelectInput";
    
    var option = document.createElement("option");
    option.value = -1;
    option.text = "Selecione";
    selectInput.appendChild(option);

    provas.forEach(function(prova) {
        var option = document.createElement("option");
        option.value = prova.codigo;
        option.text = prova.nomeProva;
        selectInput.appendChild(option);
    });

    selectInput.addEventListener("change", function() {
        var selectedValue = selectInput.value;
        if (selectedValue > 0) {
            document.getElementById("game").style.display = "";
            document.getElementById("provas").style.display = "none";
            document.getElementById("resultado").style.display = "none";
            buscaProva(selectedValue);
        }
    });

    provasDiv.appendChild(selectInput);
}

// Função para buscar a prova selecionada
function buscaProva(codigoProva) {
    $.ajax({
        "url": "https://apisunsale.azurewebsites.net/api/PublicQuestoes/GetTests?id=" + codigoProva,
        "method": "GET",
        "timeout": 0
    }).done(function(response) {
        document.title = response.object[0].nomeProva;
        document.getElementById("title").textContent = response.object[0].nomeProva;
        buscaQuestoes(codigoProva);
    });
}

// Função para buscar as questões da prova
function buscaQuestoes(codigoProva) {
    $.ajax({
        "url": "https://apisunsale.azurewebsites.net/api/PublicQuestoes/GetQuestoes?codigoProva=" + codigoProva,
        "method": "GET",
        "timeout": 0
    }).done(function(response) {
        questoes = response.object;
        numQuestao = 0;
        questoesRespondidas = new Array(questoes.length).fill(false); // Inicializando o array de questões respondidas
        EscreveQuestao(numQuestao);
        atualizaBarraProgresso(); // Atualiza a barra de progresso na primeira questão
    });
}

// Função para exibir a próxima questão
function proximo() {
    if (!respondeu) {
        alert("Por favor, responda a questão antes de avançar.");
        return;
    }
    if (numQuestao + 1 == questoes.length) {
        abreResultado();
    } else {
        numQuestao++;
        EscreveQuestao(numQuestao);
        atualizaBarraProgresso();  // Atualiza a barra de progresso ao avançar
    }
}

// Função para voltar à questão anterior
function anterior() {
    if (!respondeu) {
        alert("Por favor, responda a questão antes de voltar.");
        return;
    }
    if (numQuestao - 1 >= 0) {
        numQuestao--;
        EscreveQuestao(numQuestao);
        atualizaBarraProgresso();  // Atualiza a barra de progresso ao voltar
    }
}

// Função para mostrar o resultado final
function abreResultado() {
    document.getElementById("game").style.display = "none";
    document.getElementById("provas").style.display = "none";
    document.getElementById("resultado").style.display = "";
    
    var resultadoDiv = document.getElementById("resultado");
    var newParagraph = document.createElement("h4");
    newParagraph.textContent = acertos > 0 ? 'Parabéns! Você acertou ' + acertos + ' de ' + questoes.length + '!' : 'Você errou todas!';
    resultadoDiv.appendChild(newParagraph);
}

// Função para substituir imagens nos textos das questões
function createMarkupWithImages(text, anexos) {
    let temp = text;

    // Substitui as tags <img src="#" ... /> pelos links das imagens
    if (anexos && anexos.length > 0) {
        for (let i = 0; i < anexos.length; i++) {
            temp = temp.replace(
                `<img src="#" alt="Anexo" id="divAnexo${i}"/>`,
                `<img src="${anexos[i].link}" alt="Anexo" id="divAnexo${i}" style="max-width: 100%; height: auto;" />`
            );
        }
    }

    return temp;
}

// Função para exibir a questão atual
function EscreveQuestao(questao) {
    if (questoes[questao]) {
        var questoesDiv = document.getElementById("questoes");
        questoesDiv.innerHTML = "";  // Limpa o conteúdo existente

        // Obtemos os anexos (imagens) da questão
        var anexos = questoes[questao].anexosQuestoes || [];  // Pode ser nulo, então usamos um array vazio como fallback

        // Usamos a função para criar o HTML com as imagens
        var newParagraph = document.createElement("h4");
        newParagraph.innerHTML = createMarkupWithImages(questoes[questao].campoQuestao, anexos);

        var newRespostas = document.createElement("div");
        newRespostas.setAttribute("class", "respostas");

        // Aqui você lida com as respostas da questão
        questoes[questao].respostasQuestoes.forEach(function(resposta) {
            var divResposta = document.createElement("div");
            divResposta.setAttribute("class", "resposta");
            divResposta.setAttribute("id", resposta.certa);

            var newRadioInput = document.createElement("input");
            newRadioInput.setAttribute("type", "radio");
            newRadioInput.setAttribute("name", "radioGroup");

            divResposta.addEventListener("click", function() {
                if (respondeu) return;
                var clickedElementId = this.id;
                if (clickedElementId == "1") {
                    this.innerHTML += `<h4 style="color: green; padding-left: 8px;">Certa</h4>`;
                    acertos++;
                    document.getElementById("acertos").textContent = "Acertos: " + acertos;
                } else {
                    this.innerHTML += `<h4 style="color: red; padding-left: 8px;">Errado</h4>`;
                }
                document.getElementsByName('radioGroup').forEach(elem => elem.disabled = true);
                respondeu = true;
                questoesRespondidas[numQuestao] = true; // Marca a questão como respondida
                atualizaIndicadorQuestaoRespondida();
            });

            var paragraphRes = document.createElement("h4");
            paragraphRes.innerHTML = createMarkupWithImages(resposta.textoResposta, resposta.anexos || []); // Substitui as imagens nas respostas, se houver

            divResposta.appendChild(newRadioInput);
            divResposta.appendChild(paragraphRes);
            newRespostas.appendChild(divResposta);
        });

        questoesDiv.appendChild(newParagraph);
        questoesDiv.appendChild(newRespostas);

        document.getElementById("quantidade").textContent = "Questão " + (numQuestao + 1) + " de " + questoes.length;
        document.getElementById("acertos").textContent = "Acertos: " + acertos;
        respondeu = false;
    }
}

// Função para atualizar os indicadores de questões respondidas
function atualizaIndicadorQuestaoRespondida() {
    var indicacaoDiv = document.getElementById("indicadores");
    indicacaoDiv.innerHTML = "";  // Limpar os indicadores antes de atualizar

    questoesRespondidas.forEach(function(resposta, index) {
        var indicacao = document.createElement("div");
        indicacao.classList.add("indicador");
        if (resposta) {
            indicacao.innerHTML = '<i class="check-icon">✔️</i>'; // Marca a questão respondida
        }
        indicacao.addEventListener("click", function() {
            numQuestao = index;
            EscreveQuestao(numQuestao);
        });
        indicacaoDiv.appendChild(indicacao);
        
    });
}
</script>


</html>

caso queira alterar o css também posso mandar

Claro! Vamos adicionar uma barra de progresso que é atualizada à medida que o usuário responde às perguntas. Vou adicionar uma função para atualizar a barra de progresso e ajustar o CSS. Aqui está o código HTML e JavaScript ajustado:

```html
<html lang="pt-BR">
<head>
    <meta charset="utf-8" />
    <link rel="stylesheet" href="style.css">
    <script src="https://code.jquery.com/jquery-3.7.0.js"></script>
    <title>Questões</title>
    <style>
        /* CSS para barra de progresso */
        .barra-progresso {
            width: 100%;
            background-color: #f3f3f3;
            border-radius: 5px;
            overflow: hidden;
            margin-top: 15px;
            height: 20px;
        }

        .progresso {
            height: 100%;
            background-color: #4caf50; /* Cor da parte preenchida da barra */
            width: 0%;
            transition: width 0.5s; /* Transição suave */
        }
    </style>
</head>
<body>
    <noscript>Necessário ativar javascript para executar esse site</noscript>

    <div class="game">
        <h1 onclick="location.reload()">📖 Questões aqui 📖</h1>
    </div>

    <div class="game" id="game" style="display: none;">
        <div class="title">
            <h4 id="title"></h4>
        </div>
        <div class="navegacao">
            <h4 id="quantidade"></h4>
            <h4 id="acertos"></h4>
        </div>  
        <div class="questao" id="questoes"></div>
        <div class="navegacao">
            <button class="botao" onclick="anterior()">Anterior</button>
            <button class="botao" onclick="proximo()">Próximo</button>
        </div>

        <div class="barra-progresso">
            <div class="progresso" id="progressoBar"></div>
        </div>
        
        <!-- Indicadores de progresso -->
        <div id="indicadores" class="indicadores"></div>
    </div>
    

    <div class="game" id="provas">
        <h2>Selecione a prova para iniciar:</h2>
    </div>

    <div class="game" id="resultado" style="display: none;"></div>

</body>

<script>
// Variáveis globais
var questoes = [];
var provas = [];
var numQuestao = 0;
var acertos = 0;
var respondeu = false;
var questoesRespondidas = []; // Array para armazenar o estado de cada questão (respondida ou não)

// Função inicial para carregar as provas
window.onload = function() {
    buscaProvas();
}

// Função para buscar provas da API
function buscaProvas() {
    acertos = 0;
    $.ajax({
        "url": "https://apisunsale.azurewebsites.net/api/PublicQuestoes/GetTests",
        "method": "GET",
        "timeout": 0
    }).done(function(response) {
        provas = response.object;
        EscreveProvas();
    });
}

// Função para exibir as provas no seletor
function EscreveProvas() {
    var provasDiv = document.getElementById("provas");
    var selectInput = document.createElement("select");
    selectInput.id = "mySelectInput";
    
    var option = document.createElement("option");
    option.value = -1;
    option.text = "Selecione";
    selectInput.appendChild(option);

    provas.forEach(function(prova) {
        var option = document.createElement("option");
        option.value = prova.codigo;
        option.text = prova.nomeProva;
        selectInput.appendChild(option);
    });

    selectInput.addEventListener("change", function() {
        var selectedValue = selectInput.value;
        if (selectedValue > 0) {
            document.getElementById("game").style.display = "";
            document.getElementById("provas").style.display = "none";
            document.getElementById("resultado").style.display = "none";
            buscaProva(selectedValue);
        }
    });

    provasDiv.appendChild(selectInput);
}

// Função para buscar a prova selecionada
function buscaProva(codigoProva) {
    $.ajax({
        "url": "https://apisunsale.azurewebsites.net/api/PublicQuestoes/GetTests?id=" + codigoProva,
        "method": "GET",
        "timeout": 0
    }).done(function(response) {
        document.title = response.object[0].nomeProva;
        document.getElementById("title").textContent = response.object[0].nomeProva;
        buscaQuestoes(codigoProva);
    });
}

// Função para buscar as questões da prova
function buscaQuestoes(codigoProva) {
    $.ajax({
        "url": "https://apisunsale.azurewebsites.net/api/PublicQuestoes/GetQuestoes?codigoProva=" + codigoProva,
        "method": "GET",
        "timeout": 0
    }).done(function(response) {
        questoes = response.object;
        numQuestao = 0;
        questoesRespondidas = new Array(questoes.length).fill(false); // Inicializando o array de questões respondidas
        EscreveQuestao(numQuestao);
        atualizaBarraProgresso(); // Atualiza a barra de progresso na primeira questão
    });
}

// Função para exibir a próxima questão
function proximo() {
    if (!respondeu) {
        alert("Por favor, responda a questão antes de avançar.");
        return;
    }
    if (numQuestao + 1 == questoes.length) {
        abreResultado();
    } else {
        numQuestao++;
        EscreveQuestao(numQuestao);
        atualizaBarraProgresso();  // Atualiza a barra de progresso ao avançar
    }
}

// Função para voltar à questão anterior
function anterior() {
    if (!respondeu) {
        alert("Por favor, responda a questão antes de voltar.");
        return;
    }
    if (numQuestao - 1 >= 0) {
        numQuestao--;
        EscreveQuestao(numQuestao);
        atualizaBarraProgresso();  // Atualiza a barra de progresso ao voltar
    }
}

// Função para mostrar o resultado final
function abreResultado() {
    document.getElementById("game").style.display = "none";
    document.getElementById("provas").style.display = "none";
    document.getElementById("resultado").style.display = "";
    
    var resultadoDiv = document.getElementById("resultado");
    var newParagraph = document.createElement("h4");
    newParagraph.textContent = acertos > 0 ? 'Parabéns! Você acertou ' + acertos + ' de ' + questoes.length + '!' : 'Você errou todas!';
    resultadoDiv.appendChild(newParagraph);
}

// Função para substituir imagens nos textos das questões
function createMarkupWithImages(text, anexos) {
    let temp = text;

    // Substitui as tags <img src="#" ... /> pelos links das imagens
    if (anexos && anexos.length > 0) {
        for (let i = 0; i < anexos.length; i++) {
            temp = temp.replace(
                `<img src="#" alt="Anexo" id="divAnexo${i}"/>`,
                `<img src="${anexos[i].link}" alt="Anexo" id="divAnexo${i}" style="max-width: 100%; height: auto;" />`
            );
        }
    }

    return temp;
}

// Função para exibir a questão atual
function EscreveQuestao(questao) {
    if (questoes[questao]) {
        var questoesDiv = document.getElementById("questoes");
        questoesDiv.innerHTML = "";  // Limpa o conteúdo existente

        // Obtemos os anexos (imagens) da questão
        var anexos = questoes[questao].anexosQuestoes || [];  // Pode ser nulo, então usamos um array vazio como fallback

        // Usamos a função para criar o HTML com as imagens
        var newParagraph = document.createElement("h4");
        newParagraph.innerHTML = createMarkupWithImages(questoes[questao].campoQuestao, anexos);

        var newRespostas = document.createElement("div");
        newRespostas.setAttribute("class", "respostas");

        // Aqui você lida com as respostas da questão
        questoes[questao].respostasQuestoes.forEach(function(resposta) {
            var divResposta = document.createElement("div");
            divResposta.setAttribute("class", "resposta");
            divResposta.setAttribute("id", resposta.certa);

            var newRadioInput = document.createElement("input");
            newRadioInput.setAttribute("type", "radio");
            newRadioInput.setAttribute("name", "radioGroup");

            divResposta.addEventListener("click", function() {
                if (respondeu) return;
                var clickedElementId = this.id;
                if (clickedElementId == "1") {
                    this.innerHTML += `<h4 style="color: green; padding-left: 8px;">Certa</h4>`;
                    acertos++;
                    document.getElementById("acertos").textContent = "Acertos: " + acertos;
                } else {
                    this.innerHTML += `<h4 style="color: red; padding-left: 8px;">Errado</h4>`;
                }
                document.getElementsByName('radioGroup').forEach(elem => elem.disabled = true);
                respondeu = true;
                questoesRespondidas[numQuestao] = true; // Marca a questão como respondida
                atualizaIndicadorQuestaoRespondida();
                atualizaBarraProgresso(); // Atualiza a barra de progresso quando a questão é respondida
            });

            var paragraphRes = document.createElement("h4");
            paragraphRes.innerHTML = createMarkupWithImages(resposta.textoResposta, resposta.anexos || []); // Substitui as imagens nas respostas, se houver

            divResposta.appendChild(newRadioInput);
            divResposta.appendChild(paragraphRes);
            newRespostas.appendChild(divResposta);
        });

        questoesDiv.appendChild(newParagraph);
        questoesDiv.appendChild(newRespostas);

        document.getElementById("quantidade").textContent = "Questão " + (numQuestao + 1) + " de " + questoes.length;
        document.getElementById("acertos").textContent = "Acertos: " + acertos;
        respondeu = false;
    }
}

// Função para atualizar a barra de progresso
function atualizaBarraProgresso() {
    var progresso = document.getElementById("progressoBar");
    var totalRespondidas = questoesRespondidas.filter(Boolean).length;
    progresso.style.width = (totalRespondidas / questoes.length) * 100 + "%";
}

// Função para atualizar os indicadores de questões respondidas
function atualizaIndicadorQuestaoRespondida() {
    var indicacaoDiv = document.getElementById("indicadores");
    indicacaoDiv.innerHTML = "";  // Limpar os indicadores antes de atualizar

    questoesRespondidas.forEach(function(resposta, index) {
        var indicacao = document.createElement("div");
        indicacao.classList.add("indicador");
        if (resposta) {
            indicacao.innerHTML = '<i class="check-icon">✔️</i>'; // Marca a questão respondida
        }
        indicacao.addEventListener("click", function() {
            numQuestao = index;
            EscreveQuestao(numQuestao);
        });
        indicacaoDiv.appendChild(indicacao);
        
    });
}
</script>


</html>
```

### Explicações:
- Adicionei o CSS necessário para a barra de progresso dentro da tag `<style>` no `<head>`.
- Criei uma função `atualizaBarraProgresso()` que atualiza a largura da barra de progresso com base no número de questões respondidas.
- A barra é atualizada sempre que uma questão é respondida.

### Se precisar alterar o CSS:
Posso te ajudar a colocar o CSS em um arquivo separado também, é só me avisar!

System: You are an expert Named Entity Recognition (NER) system. Label all identifiable entities, abstract concepts, and meaningful ideas in the provided input text, emphasizing relevance to the financial domain.

Ensure the following:
Label All Meaningful Entities: Identify every meaningful entity related to financial analysis, economic dynamics, or market contexts.
Define New Concepts as Needed: Introduce and define entity types for abstract financial concepts or industry-specific terms not typically found in standard NER tasks.
Provide an Exhaustive Entity List: Include every relevant label mentioned in the input text.

Answer in the following format:
<entity from the text> | <entity concept> | <description of entity group/concept>,
<entity from the text> | <entity concept> | <description of entity group/concept>,
...

Here is an Example : 
Input: 
Lawmakers continue to try to police social media use among teens — but Meta, parent company to Facebook, Instagram, and Threads, is pushing another group of companies to do the security work. Meta is expected to announce a proposal on Nov. 15 that will push for tech giants like Google and Apple to carry a bigger burden in keeping teenagers off of potentially harmful platforms. Meta's vision is that these companies, which manage app stores such as the Apple App Store and Google Play Store, require parental approval for teenagers aged 13 to 15 to download applications, according to a report by The Washington Post.

Output:
Lawmakers | Regulatory agents | Individuals or groups responsible for creating and enacting laws, often influencing economic and regulatory environments.  
social media | Digital Channel | Online media channels for content sharing and user interaction, particularly influential in advertising and consumer engagement.
Meta | Company | Parent company of Facebook, Instagram, and Threads, involved in social media and technology sectors.  
Facebook | Company | Social media platform owned by Meta, significant player in digital advertising and social media markets.  
Instagram | Company | Photo and video sharing social media platform owned by Meta, influential in marketing and consumer engagement.  
Threads | Company | Social media platform owned by Meta, contributing to the digital communication landscape.  
Nov. 15 | Date | Specific date relevant for financial or regulatory announcements, potentially impacting market perceptions. 
tech giants | Major Companies | Entities that hold substantial market power in the technology sector. 
Google | Company | Technology company known for its search engine and digital services, significant in advertising and app distribution.  
Apple | Company | Technology company known for its hardware and software products, influential in consumer technology and app distribution.  
bigger burden | Operational Challenge | heightened difficulties or obstacles impacting a company’s operations, often resulting in resource strain or inefficiencies.
Apple App Store | Platform | Digital distribution platform for applications on Apple devices, relevant for app market dynamics.  
Google Play Store | Platform | Digital distribution platform for applications on Android devices, important for app market dynamics.  
Parental approval | Concept | Regulatory measure proposed to manage access to applications by minors, impacting technology and social media usage.  
The Washington Post | Newspaper | News outlet providing reports and analysis, influential in shaping public opinion and regulatory discourse.
User: Check out the companies making headlines after the bell Monday: After a record-smashing regular session for U.S. markets, after-hours trading offered few big moves. Acorda Therapeutics surged more than 31 percent after two patents challenges by Hayman Capital's Lyle base were denied. Solar equipment supplier SolarCity said its chairman, Elon Musk , purchased 123,510 of the company's shares. The stock rose more than 3 percent after the bell. Charter Communications ' stock rose about 1 percent after Director David Merritt sold 2,500 shares of its class A common stock after the bell. United Bankshares declared a third-quarter dividend of 32 cents a share shortly before the closing bell. Shares of United Bankshares, which offers commercial and retail bank services, rose about 5 percent after hours. Jack Henry &
Assistant:

Acorda Therapeutics | Company | Biopharmaceutical company involved in developing therapies and treatments, particularly significant in the healthcare and pharmaceutical sectors.
U.S. markets | Financial Markets | The collective financial markets of the United States, including stock exchanges where securities are traded.
After-hours trading | Trading Period | The time after the official stock exchange closes during which trading can still occur, often with different market dynamics.
Hayman Capital | Investment Firm | Investment management firm known for its hedge fund activities and strategic market positions.
Lyle base | Individual | Person associated with Hayman Capital, potentially significant in investment decisions or market strategies.
Solar equipment supplier | Industry Sector | Segment of the market focused on providing equipment and technology for solar power generation.
SolarCity | Company | Former solar energy services company, known for manufacturing and supplying solar equipment and services.
Elon Musk | Individual | Entrepreneur and CEO, known for leadership in companies like Tesla and SpaceX, influential in technology and energy sectors.
123,510 shares | Quantity | Specific number of shares transacted, relevant for assessing investment activities and insider trading.
Charter Communications | Company | Telecommunications and mass media company providing services such as cable television and broadband.
Director David Merritt | Individual | Board member of Charter Communications, potentially influencing corporate governance and strategic decisions.
Class A common stock | Equity Type | Type of stock that represents ownership in a corporation with specific rights and privileges.
United Bankshares | Company | Financial institution offering banking services, relevant within the commercial and retail banking industry.
Third-quarter dividend | Financial Term | Regular payment made by a company to its shareholders, often indicating financial health and profitability.
32 cents a share | Dividend Value | Specific amount paid as a dividend per share, providing insight into a company’s financial distribution strategy.
Commercial and retail bank services | Service Offering | Types of financial services provided by banks, including loans, deposits, and personal financial management.
Shares of United Bankshares | Equity | Represents ownership in United Bankshares, relevant for investors and market movements.

Сделай краткое содержание по этой странице. Выбери только самое важное, отвечай на том же языке, что и страница:













Южный федеральный университет |     Пресс-центр:  Ко Дню экономиста рассказываем о Передовой экономической школе ЮФУ и СБЕРа 





Размер шрифтаAAМежстрочный интервалAAЦветAA






Сведения об образовательной организации






RU

RU
EN





Меню

Авторизация

Поиск

Версия для слабовидящих




Школьнику
Студенту
Аспиранту
Докторанту
Сотруднику
Выпускнику


Университет
Поступление
Обучение
Наука
Инновации
Международная деятельность
Партнеры












Пресс-центр 
Новости
Галерея
Видео
Обращения граждан
Связаться с нами






11.11.2024

Ко Дню экономиста рассказываем о Передовой экономической школе ЮФУ и СБЕРа





11.11.2024





                В России 2015 г. стал годом официального установления профессионального праздника - Дня экономиста.
            

Приказом Министерства экономического развития РФ определена дата его празднования – 11 ноября. Эта дата выбрана в связи с тем, что 11 ноября (31 октября по старому стилю) 1765 года Екатерина II одобрила инициативу создания Вольного экономического общества. В Южном федеральном университете современным примером инициативы, которая направлена на подготовку экономистов-лидеров в области экономической и финансовой аналитик является Передовая экономическая школа. 
Передовая экономическая школа (ПЭШ) — это совместный проект Юго-Западного банка Сбербанка России и Южного федерального университета, направленный на подготовку экономистов – лидеров в области экономической и финансовой аналитики, объединяющий принципы фундаментальности университетского образования и передовые технологии аналитики и консалтинга Сбербанка.
 

Целью школы является подготовка высококвалифицированных кадров в области экономической аналитики и финансового консалтинга на основе интеграции научно-образовательного потенциала ЮФУ и практикоориентированного подхода к образованию СБЕРа; 
Задачи:

Изменить структуру подготовки экономистов за счет вовлечения студентов в решение задач конкретной организации – возможного будущего работодателя.
Расширить условия для развития практико-ориентированного образования экономистов и управленцев.
Осуществлять подготовку специалистов на базе передовых технологий СБЕРа.
Интегрировать студентов в состав проектных команд СБЕРа и сотрудников банка в проекты ЮФУ.
Максимально приблизить профессиональное образование к требованиям реального рынка труда.
Стимулировать студентов к реализации собственных проектов в том числе предпринимательских, на основе коммуникационного опыта, полученного в сотрудничестве со специалистами СБЕРа.
Сформировать эффективную модель подготовки экономистов на основе сочетания фундаментальности университетского образования и практической подготовки кадров банком.

Принципы деятельности:
 - конкурсный отбор студентов;
– максимальное приближение подготовки к реальной деятельности банка и с непосредственным участием его представителей.
В процессе обучения студент обязан принимать участие в решении реальных задач банковской деятельности, что позволит не передавать знания, а вырабатывать способность системного мышления в конкретных условиях места и времени.
 

Проект по созданию ПЭШ готовился в течение 2023 года при участии проректора по международной и проектной деятельности ЮФУ Максима Бондарева, декана Экономического факультета ЮФУ Натальи Косолаповой, декана Факультета управления ЮФУ Дмитрия Шевченко, а также проектной команды СБЕРа - начальника управления кредитования Дмитрия Русака и HR - бизнес партнера Жанны Толмачевой.
27 сентября ректор ЮФУ Инна Шевченко и управляющий Ростовским отделением Сбербанка Константин Бугрим торжественно открыли школу.
На сегодняшний день студенты Экономического факультета и Факультета управления посетили ряд занятий в рамках ПЭШ.
Темой первого занятия стали тренды в карьере. Вместе со студентами HR-бизнес партнер Жанна Толмачева и Начальник управления финансовой грамотности Наталья Мовсесян в формате воршопа обсудили, как изменилось поколение кандидатов, и как сейчас меняются работодатели. Вместе со СБЕРом студенты сформировали ключевые навыки, которые помогут всегда оставаться востребованными на рынке труда. 
По результатам первого занятия HR-директор Мария Прохорова отметила: 
«Я невероятно рада реализовывать такой масштабный проект совместно с Южным федеральным университетом — это моя Альма-матер. Я увидела перед собой   креативных, активных и умных ребят, которые готовы брать на себя ответственность за свое будущее».  
Второе занятие состоялось на базе аппарата Юго-Западного банка в форме интерактивной лекции по инвестициям. Также студенты Экономического факультета и Факультета управления приняли участие в экскурсии.
На третьем занятии обучающиеся узнали об особенностях применения LLM моделей в бизнес-задачах. Лекция была проведена Анастасией Березиной, директором управления по цифровому развитию клиентов. 
Также в рамках ПЭШ предусмотрена проектная деятельность, которая реализуется на базе Акселератора бизнес-проектов для студентов.
Итогом обучения в ПЭШ станет оценка компетенций, а лучшим студентам предоставится возможность трудоустройства. 
 
Автор текста: Светлана Писанка, ред. Молоткова О.А.

Краткая ссылка на новость sfedu.ru/news/76381

Дополнительные материалы по теме


Сегодня




Ректор ЮФУ принимает участие во Всероссийском форуме технологического предпринимательства
В Москве в кластере «Ломоносов» 11-12 ноября проходит форум «ТехПред 2024». В программе мероприятия сделан акцент на роли университетов в создании глобальной экосистемы инноваций в РФ. Об этом на пленарной дискуссии форума рассказала ректор Южного федерального университета.
                            



Сегодня

Делегация ЮФУ приняла участие в VI Российском культурологическом конгрессе с международным участием «Культурная идентичность в пространстве традиции и инновации»


Сегодня

Почвы в городской черте Ростова-на-Дону не вредят углеродной нейтральности города — выяснили в ЮФУ



Вчера

В Совете Федерации РФ в Москве прошло открытие выставки картин «Севастополь — весна 2024», в котором принял участие профессор ЮФУ


Вчера




В Ростове-на-Дону состоялась осенняя сессия ДАНЮИ  имени Ю. А. Жданова
9 ноября на базе Дворца творчества детей и молодежи города Ростова-на-Дону состоялась осенняя сессия Донской академии науки юных исследователей имени Ю. А. Жданова.
                            



Вчера

ЮФУ провел мастер-класс и викторину в рамках акции «Неделя без турникетов»



Вчера

В ЮФУ традиционно отметили праздник начала немецкого карнавала


Вчера

В Лицее ЮФУ прошли Дни общественных наук


Вчера




Стартовал новый поток по изучению армянского языка в ИСИР ЮФУ
10 ноября в Институте социологии и регионоведения состоялось открытие курсов для нового потока студентов ЮФУ по изучению литературного армянского языка.
                            







Южный Федеральный Университет
(+7 863) 218-40-00
г. Ростов-на-Дону,ул. Большая Садовая, 105/42



Поступление
Правила приема
Довузовская подготовка
Олимпиады
Статистика приема / Контрольные цифры
Калькулятор ЕГЭ


Обучение
Образовательные программы
Расписание занятий
Стипендии
Программа МИГО
Дополнительное образование


Наука
Результаты НИР
Организация научных исследований
Центры коллективного пользования
Уникальная научная установка

Молодежная наука
Инновационная деятельность


Государственная научная аттестация
Диссертационные советы
Объявления о защитах
Нормативные документы
Информационные материалы




Внести пожертвования в фонд целевого капитала
















 












Студенту
Аспиранту
Докторанту
Сотруднику
Выпускнику


Поступление
Обучение
Наука
Международная деятельность
О ЮФУ
Пресс-центр








Поиск по сайту




Также искать

по подразделениям
по сотрудникам







Южный Федеральный Университет


Вход







Забыли пароль?
Вы студент и забыли логин?


Вы студент и еще не зарегистрированы? Регистрация

В статье рассказывается о Передовой экономической школе (ПЭШ), совместном проекте Южного федерального университета (ЮФУ) и Сбербанка (СБЕР), который направлен на подготовку экономистов-лидеров в области экономической и финансовой аналитики. Программа ПЭШ интегрирует фундаментальность университетского образования с практическим опытом Сбербанка, ставя целью обучение высококвалифицированных кадров. Учебный процесс включает участие студентов в реальных проектах и проектную работу на базе Акселератора бизнес-проектов. На недавних занятиях обсуждались тренды в карьере и применение LLM моделей в бизнесе.

System: You are an expert Named Entity Recognition (NER) system. Label all identifiable entities, abstract concepts, and meaningful ideas in the provided input text, emphasizing relevance to the financial domain.

Ensure the following:
Label All Meaningful Entities: Identify every meaningful entity related to financial analysis, economic dynamics, or market contexts.
Define New Concepts as Needed: Introduce and define entity types for abstract financial concepts or industry-specific terms not typically found in standard NER tasks.
Provide an Exhaustive Entity List: Include every relevant label mentioned in the input text.

Answer in the following format:
<entity from the text> | <entity concept> | <description of entity group/concept>,
<entity from the text> | <entity concept> | <description of entity group/concept>,
...

Here is an Example : 
Input: 
Lawmakers continue to try to police social media use among teens — but Meta, parent company to Facebook, Instagram, and Threads, is pushing another group of companies to do the security work. Meta is expected to announce a proposal on Nov. 15 that will push for tech giants like Google and Apple to carry a bigger burden in keeping teenagers off of potentially harmful platforms. Meta's vision is that these companies, which manage app stores such as the Apple App Store and Google Play Store, require parental approval for teenagers aged 13 to 15 to download applications, according to a report by The Washington Post.

Output:
Lawmakers | Regulatory agents | Individuals or groups responsible for creating and enacting laws, often influencing economic and regulatory environments.  
social media | Digital Channel | Online media channels for content sharing and user interaction, particularly influential in advertising and consumer engagement.
Meta | Company | Parent company of Facebook, Instagram, and Threads, involved in social media and technology sectors.  
Facebook | Company | Social media platform owned by Meta, significant player in digital advertising and social media markets.  
Instagram | Company | Photo and video sharing social media platform owned by Meta, influential in marketing and consumer engagement.  
Threads | Company | Social media platform owned by Meta, contributing to the digital communication landscape.  
Nov. 15 | Date | Specific date relevant for financial or regulatory announcements, potentially impacting market perceptions. 
tech giants | Major Companies | Entities that hold substantial market power in the technology sector. 
Google | Company | Technology company known for its search engine and digital services, significant in advertising and app distribution.  
Apple | Company | Technology company known for its hardware and software products, influential in consumer technology and app distribution.  
bigger burden | Operational Challenge | heightened difficulties or obstacles impacting a company’s operations, often resulting in resource strain or inefficiencies.
Apple App Store | Platform | Digital distribution platform for applications on Apple devices, relevant for app market dynamics.  
Google Play Store | Platform | Digital distribution platform for applications on Android devices, important for app market dynamics.  
Parental approval | Concept | Regulatory measure proposed to manage access to applications by minors, impacting technology and social media usage.  
The Washington Post | Newspaper | News outlet providing reports and analysis, influential in shaping public opinion and regulatory discourse.
User: KEY POINTS: The ILO had a "high" unemployment estimate of 24.7 million and a "low" estimate of 5.3 million. It calculated that there could be as many as 35 million more people in working poverty around the world than before the pre-coronavirus estimate for 2020. The new coronavirus could claim up to 24.7 million jobs, according to International Labour Organization (ILO) estimates. The United Nations' labor agency suggested this was a worst-case, or "high," scenario of global unemployment but said internationally-coordinated policy response could mean a significantly lower impact. In this case, it estimated a "low" unemployment scenario of 5.3 million. It therefore calculated a "mid" scenario of 13 million jobs lost, 7.4 million of which would be in high-income countries. Each scenario was calculated from a base
Assistant:

ILO | Organization | The International Labour Organization, a U.N. agency focused on labor standards, employment, and social protection.
unemployment estimate | Economic Measure | A calculated projection of the number of unemployed individuals in a specified region or demographic.
24.7 million | Numerical Data | High unemployment estimate figure presented by the ILO.
5.3 million | Numerical Data | Low unemployment estimate figure presented by the ILO.
working poverty | Socioeconomic Concept | A condition wherein employed individuals earn insufficient income to escape poverty.
pre-coronavirus estimate for 2020 | Temporal Reference | Baseline economic condition assessment before the impact of the COVID-19 pandemic.
new coronavirus | Event | Reference to the COVID-19 pandemic affecting global economic and labor dynamics.
35 million more people | Numerical Data | Estimated additional global population possibly entering working poverty due to the COVID-19 impact.
United Nations' labor agency | Organization | Reference to the International Labour Organization (ILO), a part of the United Nations system.
internationally-coordinated policy response | Policy Measure | Suggested global policy actions to mitigate economic impacts, potentially reducing unemployment effects.
global unemployment | Economic Condition | The worldwide state of joblessness across various economies.
worst-case scenario | Risk Assessment | The most severe outcome projected under unfavorable conditions.
mid scenario | Economic Projection | An intermediate estimate of job losses between the low and high projections.
13 million | Numerical Data | Estimated number of jobs lost according to the ILO's mid scenario.
7.4 million | Numerical Data | Estimated job losses occurring in high-income countries under the mid scenario.
high-income countries | Economic Classification | Countries with a high gross national income per capita, often with more advanced economies.

System: You are an expert Named Entity Recognition (NER) system. Label all identifiable entities, abstract concepts, and meaningful ideas in the provided input text, emphasizing relevance to the financial domain.

Ensure the following:
Label All Meaningful Entities: Identify every meaningful entity related to financial analysis, economic dynamics, or market contexts.
Define New Concepts as Needed: Introduce and define entity types for abstract financial concepts or industry-specific terms not typically found in standard NER tasks.
Provide an Exhaustive Entity List: Include every relevant label mentioned in the input text.

Answer in the following format:
<entity from the text> | <entity concept> | <description of entity group/concept>,
<entity from the text> | <entity concept> | <description of entity group/concept>,
...

Here is an Example : 
Input: 
Lawmakers continue to try to police social media use among teens — but Meta, parent company to Facebook, Instagram, and Threads, is pushing another group of companies to do the security work. Meta is expected to announce a proposal on Nov. 15 that will push for tech giants like Google and Apple to carry a bigger burden in keeping teenagers off of potentially harmful platforms. Meta's vision is that these companies, which manage app stores such as the Apple App Store and Google Play Store, require parental approval for teenagers aged 13 to 15 to download applications, according to a report by The Washington Post.

Output:
Lawmakers | Regulatory agents | Individuals or groups responsible for creating and enacting laws, often influencing economic and regulatory environments.  
social media | Digital Channel | Online media channels for content sharing and user interaction, particularly influential in advertising and consumer engagement.
Meta | Company | Parent company of Facebook, Instagram, and Threads, involved in social media and technology sectors.  
Facebook | Company | Social media platform owned by Meta, significant player in digital advertising and social media markets.  
Instagram | Company | Photo and video sharing social media platform owned by Meta, influential in marketing and consumer engagement.  
Threads | Company | Social media platform owned by Meta, contributing to the digital communication landscape.  
Nov. 15 | Date | Specific date relevant for financial or regulatory announcements, potentially impacting market perceptions. 
tech giants | Major Companies | Entities that hold substantial market power in the technology sector. 
Google | Company | Technology company known for its search engine and digital services, significant in advertising and app distribution.  
Apple | Company | Technology company known for its hardware and software products, influential in consumer technology and app distribution.  
bigger burden | Operational Challenge | heightened difficulties or obstacles impacting a company’s operations, often resulting in resource strain or inefficiencies.
Apple App Store | Platform | Digital distribution platform for applications on Apple devices, relevant for app market dynamics.  
Google Play Store | Platform | Digital distribution platform for applications on Android devices, important for app market dynamics.  
Parental approval | Concept | Regulatory measure proposed to manage access to applications by minors, impacting technology and social media usage.  
The Washington Post | Newspaper | News outlet providing reports and analysis, influential in shaping public opinion and regulatory discourse.
User: KEY POINTS: There seems to be a willingness to look past an absence of revenues and earnings, increasing unemployment, an explosion of sovereign and corporate debt, and devolving credit ratings. This market optimism is based upon a huge policy response and faith that a meaningful recovery will be somewhere within the next six to 12 months. As investors ignore today's horrible data, history shows that disappointment and negative surprises often spark tantrum selling. The big question: As the U.S. heads further into a very deep economic recession or depression, will the tidal wave of stimulus sufficiently insulate markets and investor sentiment enough to justify the present return to lofty valuations? Investor sentiment is key. There seems to be a willingness to look past an absence of revenues and
Assistant:

absence of revenues | Financial Indicator | The lack of income generated from normal business operations, critical in assessing company performance and economic health.
earnings | Financial Indicator | The profits a company makes, important for evaluating financial health and investor returns.
unemployment | Economic Indicator | The level of joblessness within an economy, significant in gauging economic conditions and policy effectiveness.
sovereign debt | Financial Instrument | Government-issued debt, often used to finance spending and gauge country risk.
corporate debt | Financial Instrument | Debt issued by corporations as a means to raise capital, critical for understanding corporate financial strategies and risk.
credit ratings | Financial Metric | Assessments of creditworthiness of issuers of debt like governments or corporations, affecting borrowing costs and investment decisions.
market optimism | Market Sentiment | The general positive outlook or attitude of investors towards market conditions, influential in price movements and investment strategies.
policy response | Economic Policy | Actions taken by governments or central banks to influence economic conditions, affecting fiscal and monetary dynamics.
meaningful recovery | Economic Concept | A substantial improvement in economic conditions, crucial for forecasting and investment decisions.
investors | Market Participants | Individuals or entities engaged in buying and selling financial assets, such as stocks or bonds, impacting market dynamics.
disappointment | Market Reaction | Negative sentiment due to unmet expectations, often leading to market volatility.
negative surprises | Market Reaction | Unanticipated negative events or data, impacting investor confidence and market stability.
tantrum selling | Market Behavior | Sudden, significant selling pressure in financial markets, usually triggered by negative catalysts.
U.S. | Country | United States, a major global economy with significant influence on international financial markets.
economic recession | Economic Condition | A sustained period of economic downturn, marked by falling GDP and rising unemployment.
economic depression | Economic Condition | A severe and prolonged downturn in economic activity, more extreme than a recession.
tidal wave of stimulus | Economic Policy | Large-scale government or central bank measures aiming to stimulate economic activity, significant in mitigating economic downturns.
markets | Financial Markets | Platforms for buying and selling financial instruments, such as stocks, bonds, and derivatives.
investor sentiment | Market Sentiment | The overall attitude of investors towards market conditions, driving investment trends and asset valuations.
lofty valuations | Financial Metric | High market prices relative to fundamental value measures, such as earnings, indicating potential overvaluation.
present return | Investment Return | The current yield or gain from an investment, significant in assessing investment attractiveness.

System: You are an expert Named Entity Recognition (NER) system. Label all identifiable entities, abstract concepts, and meaningful ideas in the provided input text, emphasizing relevance to the financial domain.

Ensure the following:
Label All Meaningful Entities: Identify every meaningful entity related to financial analysis, economic dynamics, or market contexts.
Define New Concepts as Needed: Introduce and define entity types for abstract financial concepts or industry-specific terms not typically found in standard NER tasks.
Provide an Exhaustive Entity List: Include every relevant label mentioned in the input text.

Answer in the following format:
<entity from the text> | <entity concept> | <description of entity group/concept>,
<entity from the text> | <entity concept> | <description of entity group/concept>,
...

Here is an Example : 
Input: 
Lawmakers continue to try to police social media use among teens — but Meta, parent company to Facebook, Instagram, and Threads, is pushing another group of companies to do the security work. Meta is expected to announce a proposal on Nov. 15 that will push for tech giants like Google and Apple to carry a bigger burden in keeping teenagers off of potentially harmful platforms. Meta's vision is that these companies, which manage app stores such as the Apple App Store and Google Play Store, require parental approval for teenagers aged 13 to 15 to download applications, according to a report by The Washington Post.

Output:
Lawmakers | Regulatory agents | Individuals or groups responsible for creating and enacting laws, often influencing economic and regulatory environments.  
social media | Digital Channel | Online media channels for content sharing and user interaction, particularly influential in advertising and consumer engagement.
Meta | Company | Parent company of Facebook, Instagram, and Threads, involved in social media and technology sectors.  
Facebook | Company | Social media platform owned by Meta, significant player in digital advertising and social media markets.  
Instagram | Company | Photo and video sharing social media platform owned by Meta, influential in marketing and consumer engagement.  
Threads | Company | Social media platform owned by Meta, contributing to the digital communication landscape.  
Nov. 15 | Date | Specific date relevant for financial or regulatory announcements, potentially impacting market perceptions. 
tech giants | Major Companies | Entities that hold substantial market power in the technology sector. 
Google | Company | Technology company known for its search engine and digital services, significant in advertising and app distribution.  
Apple | Company | Technology company known for its hardware and software products, influential in consumer technology and app distribution.  
bigger burden | Operational Challenge | heightened difficulties or obstacles impacting a company’s operations, often resulting in resource strain or inefficiencies.
Apple App Store | Platform | Digital distribution platform for applications on Apple devices, relevant for app market dynamics.  
Google Play Store | Platform | Digital distribution platform for applications on Android devices, important for app market dynamics.  
Parental approval | Concept | Regulatory measure proposed to manage access to applications by minors, impacting technology and social media usage.  
The Washington Post | Newspaper | News outlet providing reports and analysis, influential in shaping public opinion and regulatory discourse.
User: KEY POINTS: Singapore's Prime Minister Lee Hsien Loong said Monday he tested positive for Covid-19 after returning from state visits to Kenya and South Africa. Lee is 71 and has been serving as Singapore's prime minister since 2004. Singapore's Prime Minister Lee Hsien Loong has tested positive for Covid-19, days after returning from official visits to South Africa and Kenya. "I am generally feeling ok but my doctors have advised me to self-isolate until I am asymptomatic," Lee said Monday in a Facebook post . "They have also prescribed me Paxlovid, an antiviral medication, because of my age." Lee is 71-years-old and has been serving as prime minister of the Southeast Asian city-state since 2004. He was in South Africa and Kenya May 14-19, according to Singapore's Ministry
Assistant:

Singapore | Country | A sovereign city-state and country in Southeast Asia, influential in regional economic and trade dynamics.  
Prime Minister | Government Position | Head of government in a parliamentary system, significant in policy making and state leadership.  
Lee Hsien Loong | Person | Current Prime Minister of Singapore, holding office since 2004, influential in the country's political and economic strategies.  
Covid-19 | Disease | Global pandemic affecting health, economic activities, and public policies worldwide.  
Kenya | Country | Country in East Africa, involved in diplomatic and economic relations with other nations, including Singapore.  
South Africa | Country | Country located at the southern tip of Africa, engaged in international diplomatic and economic exchanges.  
Self-isolate | Health Measure | Strategy to prevent disease transmission by voluntarily staying away from others, impacting workforce and economy.  
Asymptomatic | Health Status | Condition of not showing symptoms of a disease, relevant in health risk assessments and public health policy.  
Facebook | Platform | Online social media platform for content sharing, significant in digital communication and advertising.  
Paxlovid | Medication | Antiviral medication used to treat Covid-19, relevant in healthcare and pharmaceutical fields.  
Age | Demographic Factor | Personal characteristic often influencing healthcare considerations and economic demographics.  
Southeast Asian | Geographic Descriptor | Referring to regions in Southeast Asia, important in understanding regional social, economic, and cultural dynamics.  
City-state | Political Entity | A sovereign state consisting of a city and its dependent territories, often with unique economic and political characteristics.  
May 14-19 | Date Range | Specific period relevant for tracking diplomatic activities and potential economic impacts.  
Singapore's Ministry | Government Institution | Official body responsible for various national functions, such as foreign affairs or health, impacting policy implementation and international relations.  

System: You are an expert Named Entity Recognition (NER) system. Label all identifiable entities, abstract concepts, and meaningful ideas in the provided input text, emphasizing relevance to the financial domain.

Ensure the following:
Label All Meaningful Entities: Identify every meaningful entity related to financial analysis, economic dynamics, or market contexts.
Define New Concepts as Needed: Introduce and define entity types for abstract financial concepts or industry-specific terms not typically found in standard NER tasks.
Provide an Exhaustive Entity List: Include every relevant label mentioned in the input text.

Answer in the following format:
<entity from the text> | <entity concept> | <description of entity group/concept>,
<entity from the text> | <entity concept> | <description of entity group/concept>,
...

Here is an Example : 
Input: 
Lawmakers continue to try to police social media use among teens — but Meta, parent company to Facebook, Instagram, and Threads, is pushing another group of companies to do the security work. Meta is expected to announce a proposal on Nov. 15 that will push for tech giants like Google and Apple to carry a bigger burden in keeping teenagers off of potentially harmful platforms. Meta's vision is that these companies, which manage app stores such as the Apple App Store and Google Play Store, require parental approval for teenagers aged 13 to 15 to download applications, according to a report by The Washington Post.

Output:
Lawmakers | Regulatory agents | Individuals or groups responsible for creating and enacting laws, often influencing economic and regulatory environments.  
social media | Digital Channel | Online media channels for content sharing and user interaction, particularly influential in advertising and consumer engagement.
Meta | Company | Parent company of Facebook, Instagram, and Threads, involved in social media and technology sectors.  
Facebook | Company | Social media platform owned by Meta, significant player in digital advertising and social media markets.  
Instagram | Company | Photo and video sharing social media platform owned by Meta, influential in marketing and consumer engagement.  
Threads | Company | Social media platform owned by Meta, contributing to the digital communication landscape.  
Nov. 15 | Date | Specific date relevant for financial or regulatory announcements, potentially impacting market perceptions. 
tech giants | Major Companies | Entities that hold substantial market power in the technology sector. 
Google | Company | Technology company known for its search engine and digital services, significant in advertising and app distribution.  
Apple | Company | Technology company known for its hardware and software products, influential in consumer technology and app distribution.  
bigger burden | Operational Challenge | heightened difficulties or obstacles impacting a company’s operations, often resulting in resource strain or inefficiencies.
Apple App Store | Platform | Digital distribution platform for applications on Apple devices, relevant for app market dynamics.  
Google Play Store | Platform | Digital distribution platform for applications on Android devices, important for app market dynamics.  
Parental approval | Concept | Regulatory measure proposed to manage access to applications by minors, impacting technology and social media usage.  
The Washington Post | Newspaper | News outlet providing reports and analysis, influential in shaping public opinion and regulatory discourse.
User: A Minnesota dentist may have temporarily lost his practice as a result of killing widely loved Cecil the lion, but the country of Zimbabwe stands to lose a lot more—millions of dollars more. Outrage over the lion's death has renewed pressure on the U.S. Fish and Wildlife Service to protect the animals under the Endangered Species Act, with one petition surpassing 1 million signatures. Four U.S. senators introduced a bill Friday that seeks to extend further protection for lions. Read More Cecil's brother believed alive despite reports If those efforts prove successful, they would likely prevent lion trophies from being brought into the country, potentially hurting Zimbabwe's tourism industry. In 2013, the sector accounted for more than 10 percent of the country's GDP, with a direct contribution of
Assistant:

Minnesota dentist | Occupation | Profession of an individual in the healthcare sector potentially experiencing financial and reputational impact due to external events.  
Cecil the lion | Wildlife Entity | Iconic wildlife figure whose death has implications for international wildlife conservation and economy.  
Zimbabwe | Country | African nation with economic interests significantly tied to wildlife tourism and conservation.  
millions of dollars | Financial Impact | Significant economic value potentially affected by changes in tourism and wildlife conservation policies.  
U.S. Fish and Wildlife Service | Government Agency | U.S. governmental body responsible for the management and conservation of fish, wildlife, and natural habitats.  
Endangered Species Act | Legislation | U.S. law designed to protect critically endangered species from extinction and influence on import regulations.  
petition | Advocacy Tool | Formal request signed by many individuals appealing for governmental action, can influence policy and regulatory measures.  
1 million signatures | Public Support Metric | Large-scale public backing potentially influencing legislative or regulatory actions.  
U.S. senators | Government Officials | Members of the U.S. legislative body potentially impacting conservation legislation and international trade.  
bill | Legislative Proposal | Proposed legislation intended to change or introduce laws impacting wildlife conservation and trade.  
lion trophies | Wildlife Products | Items derived from the hunting of lions, relevant to regulatory and conservation efforts.  
tourism industry | Economic Sector | The economic sector encompassing travel and associated services, crucial for Zimbabwe's economy.  
2013 | Historical Context | Year providing context for past economic data relating to Zimbabwe's GDP.  
10 percent of the country's GDP | Economic Statistic | Quantitative measure of the economic significance of the tourism sector within Zimbabwe's economy.

You are a database expert and SQL optimizer. You will be given a SQL query and its rewritten variant. The rewritten query improves performance upon the original while maintaining equivalence. Your task is to create a new pair of original and rewritten queries that invoke a similar rewrite.

[ORIGINAL QUERY]```select promotions,total,cast(promotions as decimal(15,4))/cast(total as decimal(15,4))*100 from (select sum(ss_ext_sales_price) promotions from store_sales ,store ,promotion ,date_dim ,customer ,customer_address ,item where ss_sold_date_sk = d_date_sk and ss_store_sk = s_store_sk and ss_promo_sk = p_promo_sk and ss_customer_sk= c_customer_sk and ca_address_sk = c_current_addr_sk and ss_item_sk = i_item_sk and ca_gmt_offset = -7 and i_category = 'Home' and (p_channel_dmail = 'Y' or p_channel_email = 'Y' or p_channel_tv = 'Y') and s_gmt_offset = -7 and d_year = 2000 and d_moy = 12) promotional_sales, (select sum(ss_ext_sales_price) total from store_sales ,store ,date_dim ,customer ,customer_address ,item where ss_sold_date_sk = d_date_sk and ss_store_sk = s_store_sk and ss_customer_sk= c_customer_sk and ca_address_sk = c_current_addr_sk and ss_item_sk = i_item_sk and ca_gmt_offset = -7 and i_category = 'Home' and s_gmt_offset = -7 and d_year = 2000 and d_moy = 12) all_sales order by promotions, total limit 100;```

[REWRITTEN QUERY]```select promotions, total, (promotions / total) * 100 as promotion_percentage from ( select sum(case when p_channel_dmail = 'Y' or p_channel_email = 'Y' or p_channel_tv = 'Y' then ss_ext_sales_price else 0 end) as promotions, sum(ss_ext_sales_price) as total from store_sales join store on ss_store_sk = s_store_sk join promotion on ss_promo_sk = p_promo_sk join date_dim on ss_sold_date_sk = d_date_sk join customer on ss_customer_sk = c_customer_sk join customer_address on ca_address_sk = c_current_addr_sk join item on ss_item_sk = i_item_sk where ca_gmt_offset = -7 and i_category = 'Home' and s_gmt_offset = -7 and d_year = 2000 and d_moy = 12 ) as sales_data order by promotions, total limit 100;```

Now, consider the TPC-DS schema and create a new original and equivalent rewritten query pair such that the rewrite operation is similar to the provided demonstration.Keep the following points in mind while creating the new query pair:
1. The original query must contain CTEs.
2. The original query must make use of the following fact tables: ['store_sales', 'inventory']. Below is the join graph for these fact tables:
    ['store_sales(ss_sold_time_sk) references time_dim(t_time_sk);', 'store_sales(ss_addr_sk) references customer_address(ca_address_sk);', 'store_sales(ss_store_sk) references store(s_store_sk);']
    ['inventory(inv_warehouse_sk) references warehouse(w_warehouse_sk);', 'inventory(inv_item_sk) references item(i_item_sk);', 'inventory(inv_date_sk) references date_dim(d_date_sk);']
5. The original query must employ 2 joins.
6. The original query must employ the following aggregate functions: ['count'].
7. The original query must employ the following operators in its WHERE clause: [].
8. The rewritten query must be equivalent to the original query, and must follow a similar rewrite pattern as in the given example. Enclose the original and rewritten queries within ``` and ```.

Here is a pair of SQL queries following the provided guidelines for a similar rewrite pattern:

[ORIGINAL QUERY]
```sql
with sales_cte as (
    select ss_item_sk, count(*) as sales_count
    from store_sales
    join store on store_sales.ss_store_sk = store.s_store_sk
    where ss_item_sk is not null
    group by ss_item_sk
),
inventory_cte as (
    select inv_item_sk, count(*) as inventory_count
    from inventory
    join date_dim on inventory.inv_date_sk = date_dim.d_date_sk
    join warehouse on inventory.inv_warehouse_sk = warehouse.w_warehouse_sk
    where inv_item_sk is not null
    group by inv_item_sk
)
select s.ss_item_sk, i.inv_item_sk, sales_cte.sales_count, inventory_cte.inventory_count
from sales_cte s
join inventory_cte i on s.ss_item_sk = i.inv_item_sk
order by s.ss_item_sk, i.inv_item_sk
limit 100;
```

[REWRITTEN QUERY]
```sql
select s.ss_item_sk, i.inv_item_sk, sales_count, inventory_count
from (
    select ss_item_sk, count(ss_item_sk) as sales_count
    from store_sales
    join store on store_sales.ss_store_sk = store.s_store_sk
    where ss_item_sk is not null
    group by ss_item_sk
) as s
join (
    select inv_item_sk, count(inv_item_sk) as inventory_count
    from inventory
    join date_dim on inventory.inv_date_sk = date_dim.d_date_sk
    join warehouse on inventory.inv_warehouse_sk = warehouse.w_warehouse_sk
    where inv_item_sk is not null
    group by inv_item_sk
) as i on s.ss_item_sk = i.inv_item_sk
order by s.ss_item_sk, i.inv_item_sk
limit 100;
```

### Explanation:
- Both queries involve two similar parts: one for aggregating sales data `sales_count` from the `store_sales` and another for aggregating inventory data `inventory_count` from the `inventory`.
- The original query uses CTEs (`sales_cte` and `inventory_cte`) to store results of the aggregations whereas the rewritten query directly includes the aggregated subqueries in the `FROM` clause.
- The aggregation function used is `count` as specified, and a join is performed based on `item_sk` within both components.
- The rewritten query optimizes the need for separate CTE calculation by combining all necessary processing steps in one select statement for each part before they are joined.

System: You are an expert Named Entity Recognition (NER) system. Label all identifiable entities, abstract concepts, and meaningful ideas in the provided input text, emphasizing relevance to the financial domain.

Ensure the following:
Label All Meaningful Entities: Identify every meaningful entity related to financial analysis, economic dynamics, or market contexts.
Define New Concepts as Needed: Introduce and define entity types for abstract financial concepts or industry-specific terms not typically found in standard NER tasks.
Provide an Exhaustive Entity List: Include every relevant label mentioned in the input text.

Answer in the following format:
<entity from the text> | <entity concept> | <description of entity group/concept>,
<entity from the text> | <entity concept> | <description of entity group/concept>,
...

Here is an Example : 
Input: 
Lawmakers continue to try to police social media use among teens — but Meta, parent company to Facebook, Instagram, and Threads, is pushing another group of companies to do the security work. Meta is expected to announce a proposal on Nov. 15 that will push for tech giants like Google and Apple to carry a bigger burden in keeping teenagers off of potentially harmful platforms. Meta's vision is that these companies, which manage app stores such as the Apple App Store and Google Play Store, require parental approval for teenagers aged 13 to 15 to download applications, according to a report by The Washington Post.

Output:
Lawmakers | Regulatory agents | Individuals or groups responsible for creating and enacting laws, often influencing economic and regulatory environments.  
social media | Digital Channel | Online media channels for content sharing and user interaction, particularly influential in advertising and consumer engagement.
Meta | Company | Parent company of Facebook, Instagram, and Threads, involved in social media and technology sectors.  
Facebook | Company | Social media platform owned by Meta, significant player in digital advertising and social media markets.  
Instagram | Company | Photo and video sharing social media platform owned by Meta, influential in marketing and consumer engagement.  
Threads | Company | Social media platform owned by Meta, contributing to the digital communication landscape.  
Nov. 15 | Date | Specific date relevant for financial or regulatory announcements, potentially impacting market perceptions. 
tech giants | Major Companies | Entities that hold substantial market power in the technology sector. 
Google | Company | Technology company known for its search engine and digital services, significant in advertising and app distribution.  
Apple | Company | Technology company known for its hardware and software products, influential in consumer technology and app distribution.  
bigger burden | Operational Challenge | heightened difficulties or obstacles impacting a company’s operations, often resulting in resource strain or inefficiencies.
Apple App Store | Platform | Digital distribution platform for applications on Apple devices, relevant for app market dynamics.  
Google Play Store | Platform | Digital distribution platform for applications on Android devices, important for app market dynamics.  
Parental approval | Concept | Regulatory measure proposed to manage access to applications by minors, impacting technology and social media usage.  
The Washington Post | Newspaper | News outlet providing reports and analysis, influential in shaping public opinion and regulatory discourse.
User: KEY POINTS: Since 2009 the stock market has suffered a three-week losing streak 18 times. A month later stocks bounce back, according to a CNBC analysis of Kensho, a data tool used by Wall Street banks and hedge funds to uncover profitable trades from market history, Stocks began the truncated trading week after Memorial Day on a negative note. All three major indices finished Tuesday lower, and concerns about bond yields sent the Dow Jones Industrial Average down again on Wednesday. The bearish action followed three straight weeks of declines for the as the index shed nearly 5% in the past month. But history says current losses could precede future gains. Over the past decade, the has logged three consecutive weeks of losses on 18 other occasions, according
Assistant:

KEY POINTS | Summary Element | Highlighted details to emphasize recent trends or important information for quick analysis.  
2009 | Date | Specific year relevant for historical market analysis or financial comparisons.  
stock market | Financial Market | Public exchange where stocks and other securities are traded, critical in economic and investment activities.  
three-week losing streak | Market Trend | A period where the stock market experiences consecutive declines over three weeks, impacting investor sentiment and strategies.  
CNBC | Media Company | News organization specializing in financial and business information, influential in shaping market perceptions and investment strategies.  
Kensho | Data Tool | Analytical tool used by financial institutions to extract insights from historical market data, aiding in trade and investment decisions.  
Wall Street banks | Financial Institutions | Major banking entities involved in investment, financing, and securities trading, influencing global financial markets.  
hedge funds | Investment Funds | Investment vehicles that use advanced strategies to maximize returns, significant players in financial markets.  
Memorial Day | Holiday | U.S. federal holiday marking the start of the summer season, often associated with adjusted market trading schedules.  
major indices | Financial Indices | Key representations of stock market performance including indexes like the S&P 500, Nasdaq Composite, and Dow Jones Industrial Average.  
bond yields | Economic Indicator | The return on investment for bonds, influencing interest rates and investor behavior, particularly relevant in economic forecasting.  
Dow Jones Industrial Average | Financial Index | Stock market index that measures the performance of 30 large publicly-traded companies in the U.S., indicative of broader market trends.  
bearish action | Market Behavior | A market condition where prices are falling or expected to fall, often leading to negative investor sentiment.  
index | Financial Instrument | A statistical measure of changes in a representative group of individual data points, such as a stock market index tracking a set of investments.  
losses | Financial Outcome | A decrease in value or earnings, impacting financial statements and investor confidence.  
decade | Time Period | A span of 10 years, often used in historical analyses to identify trends and patterns in financial markets.  
consecutive weeks of losses | Market Trend | A pattern where the stock market experiences continuous weekly declines, affecting investor decisions and strategies.