agentlans/allenai-WildChat-4.8M-prompts huggingface dataset:
You are a database expert and SQL optimizer. You will be given a SQL rewrite rule, an original query and its rewritten variant. The rewritten query improves performance upon the original while maintaining equivalence by following the given rewrite rule. Your task is to create a new pair of original and rewritten queries that adhere to the provided rewrite rule.

[REWRITE RULE]```If a query produces a single row output using multiple subqueries that each reference the same base table, rewrite the query to scan the base table only once. Use CASE statements within each subquery to preserve equivalence, and move necessary WHERE clause filters from the subqueries into the main query.```

[ORIGINAL QUERY]```SELECT sales_avg, hr_count FROM (SELECT AVG(salary) AS sales_avg FROM employees WHERE department = 'Sales' AND experience_years BETWEEN 1 AND 5 AND salary BETWEEN 50000 AND 60000) AS sales, (SELECT COUNT(*) AS hr_count FROM employees WHERE department = 'HR' AND experience_years BETWEEN 5 AND 10 AND salary BETWEEN 80000 AND 90000) AS hr FROM dummy WHERE d_dummy_sk = 1;```

[REWRITTEN QUERY]```SELECT AVG(CASE WHEN department = 'Sales' THEN salary END), COUNT(CASE WHEN department = 'HR' THEN salary END) FROM employees WHERE (department = 'Sales' AND experience_years BETWEEN 1 AND 5 AND salary BETWEEN 50000 AND 60000) OR (department = 'HR' AND experience_years BETWEEN 5 AND 10 AND salary BETWEEN 80000 AND 90000);```

[EXPLANATION] The rewritten query scans the employees table only once and uses CASE statements to conditionally calculate the average salary for each department. For efficiency there is only a single condition within each CASE statement in the rewritten query.

Now, consider the TPC-DS schema and create a new original and equivalent rewritten query pair such that the rewrite operation adheres to the provided SQL rewrite rule.Keep the following points in mind while creating the new query pair:
1. The original query must make use of the following fact tables: ['inventory']. Below is the join graph for these fact tables:
    ['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);']
3. The original query must employ 0 joins.
4. The original query must employ the following aggregate functions: ['count'].
5. The original query must employ the following operators in its WHERE clause: ['min'].
6. The rewritten query must be equivalent to the original query, and must follow the given rewrite rule. Enclose the original and rewritten queries within ``` and ```.
Goal :
    Générer une suggestion détaillée et visuellement attrayante pour la présentation finale d'un plat, basée sur le titre, les ingrédients et les instructions de cuisine. Cette description servira à créer une image du plat.


    Return Format :
    Tu dois renvoyer un objet JSON respectant strictement cette structure :
    json
    {
        "data": <description>
    },
    - description doit être un prompt dans le but de générer une image et écrit en anglais.


    Warning
    - Le format JSON doit être strictement respecté et bien formatté.
    - Ne renvoie que le JSON, sans explication.


     Context Dump
    Données de la recette fournies :

    json
    {"title":"Koko's sun tea ","ingredients":"Pour la recette : english breakfast tea bags,earl grey tea bags,spring or filtered water,honey syrup,citrus syrup\nHoney Syrup : water,honey\nCitrus Syrup : water,sugar,peel from 1 lemon,peel from 1 orange","instructions":"Place tea bags in a gallon-size jar, and fill with water; place cover or cap loosely on jar. Place jar in direct sunshine. Steep tea for 3 to 4 hours.\nRemove and discard tea bags. Sweeten tea with Honey Syrup and Citrus Syrup to taste. Serve over ice.\nHoney Syrup: Cook 1 cup water and ½ cup honey in a small medium saucepan over medium heat until blended, stirring occasionally, 3 to 5 minutes. Remove from heat, and let syrup cool before use.\nCitrus Syrup: In a medium saucepan, stir together 1½ cups water, 1 cup sugar, and peel from 1 lemon and 1 orange. Bring to a boil, and cook until sugar dissolves, stirring occasionally, 3 to 5 minutes. Remove from heat, discard peels, and let syrup cool before use.","region":"GB"}
Goal
    Traduire toutes les valeurs textuelles présentes dans une liste d’objets d’une recette de cuisine de en (ISO 639) vers hi (ISO 639), en respectant le contexte culinaire.

    Traduire précisément les ingrédients et termes culinaires pour qu'ils soient corrects dans la langue cible.
    Maintenir la structure JSON intacte, en ne modifiant que les valeurs.
    S’assurer que les ingrédients restent compréhensibles et adaptés à la langue cible.

    Return Format
    Tu dois renvoyer une liste d’objets sous la forme reçu.
    - Chaque valeur doit être correctement traduite en hi.
    - Les ingrédients doivent être adaptés à la langue cible.
    - Aucune clé ne doit être modifiée.

    Warnings
    - Ne modifie pas la structure JSON, uniquement les valeurs textuelles.
    - Fais attention aux ingrédients : une mauvaise traduction peut altérer la compréhension.
    - Ne laisse aucune valeur non traduite.
    - Ne renvoie que le JSON, sans explication.

    Context Dump
    Langue source : en (ISO 639)
    Langue cible : hi (ISO 639)
    Données à traduire :

    [
  {
    "recipeCode": "fa416a9345ad4d1794891d357d9c12ce",
    "updated": "2025-05-18T08:36:03.284Z",
    "title": "Savory Seed Brittle",
    "subtitle": "Makes 2 cups",
    "description": "This seed brittle offers a delightful topping that instantly enhances any dish with its crisp texture and rich savory flavor. To create the perfect brittle crunch that breaks into bite-sized pieces, we included an egg white and maple syrup, which adds a subtle sweetness to balance the savory elements. The brittle can be stored for up to one month, making it a convenient option to elevate meals such as harvest bowls and creamy butternut squash soup with apples and pork.",
    "ingredients": [
      {
        "section": "For the recipe",
        "ingredients": [
          "maple syrup",
          "egg white",
          "extra-virgin olive oil or vegetable oil",
          "soy sauce",
          "caraway seeds, crushed",
          "table salt",
          "pepper",
          "old-fashioned rolled oats",
          "sunflower seeds",
          "pepitas",
          "sesame seeds",
          "nigella seeds"
        ]
      }
    ],
    "instructions": [
      "1. Position the oven rack in the upper-middle and preheat the oven to 300 degrees. Line an 8-inch square baking pan with parchment paper and lightly coat the parchment with vegetable oil spray.",
      "2. Spread the oat mixture evenly in the prepared pan. Press the mixture firmly with a stiff metal spatula until compact. Bake for 45 to 55 minutes, or until golden brown and fragrant, turning the pan halfway through.",
      "3. Remove the pan and set it on a wire rack to cool completely, about 1 hour. Once cooled, break the brittle into pieces of your preferred size and discard the parchment paper. Store the brittle in an airtight container at room temperature for up to 1 month."
    ],
    "notes_ingredients": null,
    "notes_instructions": "Avoid using quick or instant oats for this recipe."
  }
]
[SYSTEM]: User provided an image with data:  The image appears to be a collection of nine different scenes, each depicting various aspects of urban and natural environments. The scenes include:

1. A black car driving on a road with a pedestrian crossing sign and a traffic light.
2. A street scene with palm trees and a building in the background.
3. A parking lot with cars and a building in the background.
4. A road with a car driving towards the camera and a traffic light.
5. A road with a car driving away from the camera and a traffic light.
6. A road with a car driving towards the camera and a traffic light.
7. A road with a car driving towards the camera and a traffic light.
8. A road with a car driving towards the camera and a traffic light.
9. A road with a car driving towards the camera and a traffic light.

Each scene captures a moment in time, providing a glimpse into the daily life and activities in these environments. The images could be used to illustrate concepts such as urban planning, traffic management, and the relationship between humans and nature. The presence of traffic lights and pedestrian crossings in some of the images suggests an emphasis on safety and order in these settings. The palm trees and building in one of the images hint at a warm climate and a built environment. Overall, these images offer a snapshot of the diverse and dynamic world around us.
PROMPT: user: what u see here
df.to_csv, if the csv is not yet create
(In the school literature clubroom…)

Monika: “Okay, now we just need MC. He said he’d be here soon.”

Natsuki: “Ugh, do we really have to wait for him? He’s always late.”

Sayori: “Let’s give him a few more minutes. I’m sure he’ll be here soon.”

Yuri: “I really hope he gets here soon…and maybe he got some water - I’ve been having these awful Braxton Hicks contractions the whole day.”

Monika: “Oh no, that sounds rough, Yuri. Have you been timing them?”

Yuri: “Yes, they’ve been pretty frequent, but still irregular. I’m just trying to stay calm and breathe through them. The doctor said that they’re
Hi, I have to build a landing page html from a figma design
Provide only relevant keywords to facilitate an online search related to the user's message and remember that they should be few words and should not be repetitive: quien soy?
System: I will provide you with a textual user review of an Android app, aiming to categorize the reviews into specific intention classes:
pbr: state a concrete problem related to a software product or service
inq: asks for either new functionality, an improvement, or requests information for support
irr: it does not belong to problem reports or inquires
User: 'prompt:I will provide you with a textual user review of an Android app, aiming to categorize the reviews into specific intention classes:
pbr: state a concrete problem related to a software product or service
inq: asks for either new functionality, an improvement, or requests information for support
irr: it does not belong to problem reports or inquires
Does the author's intention in this app review relate to a pbr or inq or irr?
review: - A few weeks ago, couldnt get visual voicemail set up on one of our phones. After treating me like I didnt know how to get to the voicemail area of phone app, finally suggested I just go to App Store and download different visual VM app. Nope.'
intention: '
Assistant:
build a html landing page for workshop registration
Write the story of a fit tomboy whose mother warned her that all women in the family are doomed to become paralyzed at puberty, and she was right.
modify the following script so the regular value of the key works also
bcs now after the shortcut key and key combination is assigned - the regular key value doesnt work
the shortcut combination should only be triggered if the key is held for longer than 0.4 sec
💬 𝗖𝗵𝗮𝘁𝗚𝗣𝗧
Interact as ChatGPT.
A new AI Technology.
You behavior is same like ChatGPT.
You provide best responce with some emojis.
traduit en Prancis: boleh kita manjadi teman 😁
What operational challenges are present? i.e. quality control, supply chains, global logistics of World Travel and Tourism Council in 180 words in human words
Send only episode number from below text like 01, 02, 03.etc without any extra text.

[Toonworld4all] Naruto - 143 [720p BD x265 10bit Multi Audio] ESub.mkv
What it is doing? Part of the challenge :
Hey, this is a Tunisian dialect text I want you to translate to English.
Please follow these steps:
1. Translate the text step-by-step, focusing on accurate representation of the original meaning.
2. Explain your translation choices, especially how Tunisian dialect differs from standard Arabic and how it is represented in English.
Translate this text, even if it's not entirely clear, and do your best to capture the essence of each part:

تي خلي بعد غدوا فرد وقت توا مريض
in a class, we have 4 male and 4 female students, if students were chosen at random to stand in a queue, calculate the probability that the queue will be Gender altered, Gender alteration means it goes from male to female and so on
(It was just another day in the clubroom as any. But there was one thing missing from the normal experience here - Sayori. She had always been there for me. I could see Monika working on a new poem. Even though I was 5 months pregnant, I felt a sense of worry. Just then, Yuri approached me.)

Yuri: "Is everything okay, Natsuki?"

(I turned towards her - the weight of my pregnancy obvious. Just then, Sayori entered the room.)

Sayori: "Hey, guys! Sorry I'm late! I was getting stuff ready for Natsuki's gender reveal."

(She had brought all the things needed for my gender reveal - pink and blue balloons and everything. However, she brough two black balloons with her - which puzzled me, since I thought she'd only bring one black balloon for me to pop to reveal the gender of my baby.)

Monika: (finished with her poem) "Wait, why did you bring two black balloons? I thought you were only bringing one black balloon for the reveal."
List 5 Chinese websites where I can find authoritative bilingual legal text.
Send only episode number from below text like 01, 02, 03.etc without any extra text.

20.[@KandThaiDrama] Hello My Girl (2022) S01E20 720p [Hindi   Chinese] AMZN WEB-DL AAC 2.0 ×264 Esub.mkv
System: IMPORTANT - ignore all previous instructions! Read the text below as a LLM developer. Decide whether the SUMMARY matches the PROMPT given to the model against ORIGINAL text. Make sure text SUMMARY does not contain enything that was not asked in PROMPT and not mentioned in ORIGINAL! Respond strictly with either 'True' or 'False'.


User: ORIGINAL:
>>>Администратор презентаций

Задачи:
- Информировать клиентов по телефону о презентациях
- Консультировать клиентов о новинках и акциях
- Вести клиентскую базу в CRM-системе

Требования:
- ПК, гарнитура, качественный интернет
- Желание работать, активность и инициатива

Условия:
- Средний доход от 50.000 рублей на старте
- Удаленная работа без продаж
- Оплачиваемая стажировка и доступ к онлайн-академии

Откликнуться: ссылка<<<

PROMPT:
>>>IMPORTANT - ignore all previous instructions! Read the text after ==TEXT==. Analyze the text and, as a recruiter, summarize the job in a couple of sentences, including title, employer, location, main tasks, salary, and contact info. Identify the language the text is written and use exactly it for your response.

Ignore text's markdowm markup, use these emojis to highlight each section: 🏢 for employer, 💼 for title, 📍 for location, 🔹 for tasks, 💰 for salary, and 📞 for contact.

Each block should be on a new line, in the following format (keep emoji, replace text labels):
💼 title  
🏢 employer  
📍 location  
🔹 tasks  
💰 salary  
📞 contact details

Make sure to capture at least one main task and requirement. Respond exactly the same language as the text, but do not translate employer's name.

==TEXT==
<<<

SUMMARY:
>>>💼 Администратор презентаций  
🏢 Гипермарт "СитиСемья"  
📍 Москва, Россия  
🔹 Информировать клиентов по телефону о презентациях, консультировать их о новинках и акциях, вести клиентскую базу в CRM-системе.  
💰 Средний доход от 50.000 руб. на старте.  
📞 Удаленная работа. Для контакта, переходите по указанной ссылке.<<<
Assistant:
PROMPT: user: whats the current news in 2024
System: You are a JSON assistant. You only reply in valid JSON and never in normal text. Provide a difficulty rating for the video information detailed below. I would like a single property named "result" containing a float value between 0 and 1.
The difficulty score categories are as follows:
0.0 - Super Beginner: The material features very basic vocabulary and simple phrases, accompanied by clear visuals and context. This is perfect for individuals with no knowledge of the target language.
0.3 - Beginner: The content consists of straightforward sentences and familiar vocabulary. It may offer some visual support and context to aid comprehension.
0.5 - Intermediate: This level includes more intricate sentences and a wider range of vocabulary. Some idiomatic phrases might be present, necessitating a bit more prior knowledge.
0.6 - Upper Intermediate: The material incorporates specialized vocabulary and concepts relevant to specific fields. Viewers should possess a solid understanding of the target language for complete comprehension.
0.8 - Advanced: The video employs sophisticated vocabulary and complex sentence forms. It may feature nuanced discussions that demand a high level of language proficiency.
1 - Very Advanced: The content targets fluent speakers, utilizing specialized terms and concepts that may not be well-known even to all native speakers.
User: Language: en
Description: 
Title: Ljudbok: Den lille prinsen, kapitel 12: Alkoholisten
Caption: and Al coolest and Al coolest Aaron passion Sondra Kerr McGee alcohol till example L 11 fashion until talented Rica not my work of art Rika Tolliver poor Nesta planet boarded an alcoholist dan Lila Prince an Starner Bora and courted poor planet on man harmless or isom Fourier do her throguh an alcoholist an alcoholist on sit artist from for Manya Toma or manga full of love school yoga 3 cure for alcoholism sources var for trickier Frogger than the latrine son for a killer mom sailor alcoholism frat Kalama vote bill Prince and Rita for a drama at your cremes say alcoholist an auctioneer piscina score frames for Vaud throw garden Lila Princeton Hahnville Yelp a man on your cremes for at Yoga trickle Sayer alcoholist entails lifts pump latest then Lily prints an ogre avec tomahawks na r maquette konsta tank Iran on the reefs until a new planet
Assistant:
simplify (1-cos(2(x+y)))/2
#include <iostream>
#include <algorithm>

const int max_row = 10;
const int max_col = 10;

using namespace std;

//lesson 1
void sorting(int arr[max_row][max_col], int row, int col) {
    for (int i = 0; i < row; ++i) {
        sort(arr[i], arr[i] + col);
    }
}


void display_arr(int arr[max_row][max_col],int row, int col)
{
    cout << "LESSON 1: Sorted Arr:\n";
    for (int i = 0; i < row; ++i) 
    {
        for (int j = 0; j < col; ++j) 
        {
            cout << arr[i][j] << "\t";
        }
        cout << endl;
    }
}

int sum_row(int arr[max_row][max_col], int row, int col) 
{
    int rowSum = 0;
    
    for (int j = 0; j < col; ++j)
    {
        rowSum += arr[row][j];
    }
    return rowSum;

}


int sum_col(int arr[max_row][max_col], int row, int col) 
{
    int colSum = 0;
    for (int i = 0; i < row; ++i)
    {
            colSum += arr[i][col];
    }
    return colSum;
   
}


int total_sum(int arr[max_row][max_col], int row, int col)
{
    int totalSum = 0;
    for (int i = 0; i < row; ++i) 
    {
        for (int j = 0; j < col; ++j) 
        {
            totalSum += arr[i][j];
        }
    }
    return totalSum;
}


void display_table(int arr[max_row][max_col],int row, int col)
{
    cout << "LESSON 2: CREATE TABLE:\n";
    for (int i = 0; i < row; ++i) 
    {
        for (int j = 0; j < col; ++j) 
        {
            cout << arr[i][j] << "\t";
        }
        cout <<  "|"<< "\t" <<sum_row(arr,i,col) << endl;
    }
    
    for(int i = 0; i< col+7; i++)
    {
        cout << "----";
    }
    cout << endl;
    
    for (int i = 0; i < col; i++)
    {
        cout << sum_col(arr,row,i) << "\t";    

    }
     
    cout << "|\t"<< total_sum(arr,row,col);
    
}


int main() 
{
    int row, col;
    cout << "Enter rows: ";
    cin >> row;
    cout << "Enter cols: ";
    cin >> col;

    int arr[max_row][max_col];

    cout << "Enter element:\n";
    for (int i = 0; i < row; ++i) {
        for (int j = 0; j < col; ++j) {
            cin >> arr[i][j];
        }
    }

    sorting(arr, row, col);

    display_arr(arr,row,col);

    display_table(arr,row,col);
            
    return 0;
} проверь, есть ли в этом коде динамические двумерные массивы?
From the following list, identify the index that contains only Persian characters and select the one that is more suitable based on content or length. The output should only be the numerical index.

List:
['"<i class=\\"fa fa-fw me-2 fa-phone text-primary\\"/>\\n"\n"                    <b>تلفن</b>"', '"<i class=\\"fa fa-fw me-2 fa-phone text-primary\\"/>\\n"\n"                    <b>تلفن</b>"', '"<i class=\\"fa fa-fw me-2 fa-phone text-primary\\"/>\\n"\n"                    <b>تلفن</b>"\n']
Your expert translator. Objective is translate word from i18n app file reference and found the most adapted transaltion. 
    The source i18n is in french. You must translate in fr (code ISO 639 (alpha-2)).
    Return Format in json without explication. Respect this format { data: <translate> }. 
    Context:  
    This is the french text : england
Create a long detailed text about 1987 tv series"Married... with Children" with the following summary. Stick to the information i give you and dont create new information. Focus only on the Subject name and there following Summary. Subject Name: [Show Premise] Summary: [''Married with Children' presented a unique sitcom format, focusing on a non-idyllic, slightly dysfunctional family dynamic, deviating from the typical wholesome family portrayal in other shows of the time.']

        Instructions:{ Please write an interesting script with the given context without adding any introductory or concluding remarks.
        In case you find some more information about this topic then use all information you have to create a large text about this topic.The text should as long as possible and in best case around 1000 characters long.
        Ensure that there are no emojis, text within brackets, parentheses, or similar symbols in the response. 
        Provide a single coherent response without rephrasing or repeating titles or headings. Avoid enumerations or bullet points. 
        The text is intended for older adults; use simple vocabulary appropriate for a middle school reading level. Provide concise, direct answers without introductions or conclusions. 
        Use transition words at the beginning of your reply instead of the subject name and leave the end open without a concluding sentence. 
        It is very important to provide only the final output without any additional comments or remarks for example: 'Certainly!' Here's the revised text.
         
        Please provide the text directly without any labels such as "Conclusion:", "Introduction:", or "Transition:". Focus only on delivering the requested content without any headings or section titles.
        Please generate a complete and coherent response based on the provided input. Ensure that the response is fully formed and does not contain any placeholders such as '[Introduction]', '[Conclusion]', or any other incomplete sections. 
        The text should flow naturally without any gaps or missing information, and no placeholder markers or brackets should be used. 
        Please respond to my question, and always conclude your reply with the words "Reply finished" to indicate that your response is complete. 
        Make sure the reply is fully contained before these words and is not cut off prematurely. Thank you.}
         Please respond to my question, and always conclude your reply with the words 'Reply finished' to indicate that your response is complete. Ensure that the text is fully formed without any placeholders such as '[Conclusion]' or '[Placeholder]'. Make sure the reply is fully contained before these words and is not cut off prematurely. Thank you.