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 1 joins.
4. The original query must employ the following operators in its WHERE clause: ['avg', 'min', 'max'].
5. The original query must select a column that casts a ['decimal as another decimal with different precision and scale'].
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 ```.
quais são as formas corretas para completara ( ) das frases a seguir , responda em ingles 

1. Perhaps tomorrow we ( ) Bruno and Penny.
will visit , is going to visit , is visit ?

2. Amélie's sister is pregnat. She ( ) teh baby by the end of July.
is going to have baby,will have,is having

3. Tonight it ( ). The forecast said it's going to be sunny.
ins't going to rain,ins't raining,won't rain ?

4. I dont Know yet, Chuck. But I think that I ( ) that new car.I don't have all that money.
won't buy,'mnot going to buy,'m not buyng ?

5. Sarah has alterady received her salary. Tomorrow she ( ) all her debts.
is going to pay,will pay,is paying ?

6. Pnny is not sure yet, she ( ) an appointment with DR. Clinton.
will probably set,is probably setting,is probably going to set ?

7. Sarah is sick. She has been sick for 2 days, Her mother ( ) an apponintment with her doctor this 
afteternoon. She told me. is going to set,will set,is setting?
(My name is Flame. I'm a monster rider. I've travelled across many different regions of the New World. But more importantly, I'm the only person in Mahana Village with two Elder Dragons by my side. I was raised in Kamura Village - which was under attack at the time of my birth. And due to my fascination with the bow weapon type, I became Kamura's top archer. But enough about my past - its time that I introduced you to my monsties. I have 2 Flying Wyverns, 1 Temnoceran, 1 Leviathan, and of course 2 Elder Dragons. In terms of attack style, I have two monsties for every type - two for Power, two for Speed, and two for Technical. Each attack style has one non-elder dragon and one elder dragon, except Speed - which has my Leviathan and my other Flying Wyvern, with my Speed-based Flying Wyvern also being my ace. And by the time I call my ace, watch out for the bombs he drops from the sky. My first power-based monstie is a Dreadking Rathalos - his name is Lord X. And since I have a power-based monstie named Lord X, then I've got to have one named MX, as well. This is where my most dangerous power-based monstie comes in - my unstoppable Nergigante. For the Technical-based monsties, my Temnoceran is a Nerscylla - I named her "Dark". But sometimes, Dark just doesn't get the job done. As such, I've decided that if my enemy isn't afraid of darkness, then I'd drop the temperature around them - and this is where my second Technical-based monstie, her name is "Valkyrie" by the way, comes in. And as you would have guessed, the monstie that I've given the name "Valkyrie" is an Elder Dragon. But not just any Elder Dragon - the Iceborne wyvern itself. Can you guess which elder dragon Valkyrie is?)
Goal
    Traduire toutes les valeurs textuelles présentes dans une liste d’objets d’une recette de cuisine de en (ISO 639) vers zh (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 zh.
    - 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 : zh (ISO 639)
    Données à traduire :

    [
  {
    "recipeCode": "e28a190b6b92470fba52ac905f964d3b",
    "updated": "2025-05-11T02:03:30.764Z",
    "title": "Candied Yam Cupcakes",
    "subtitle": null,
    "description": null,
    "ingredients": [
      {
        "section": "For the recipe",
        "ingredients": [
          "yams, peeled and cubed",
          "eggs",
          "canola oil",
          "white sugar",
          "vanilla extract",
          "all-purpose flour",
          "baking powder",
          "baking soda",
          "ground cinnamon",
          "salt",
          "cream cheese",
          "butter, softened",
          "vanilla extract",
          "confectioners' sugar"
        ]
      }
    ],
    "instructions": [
      "Step 1\nPlace a steamer insert into a large saucepan and add water just below the steamer's bottom. Cover and bring to a boil over high heat. Add the yams, cover again, and steam until tender, about 15 minutes. Remove the yams and let them cool slightly.",
      "Step 2\nPreheat the oven to 350 degrees F (175 degrees C). Line two 12-cup cupcake pans with paper liners.",
      "Step 3\nIn a large bowl, combine eggs, oil, sugar, vanilla extract, and cooked yams; beat with an electric mixer until light and fluffy. In a separate bowl, sift together flour, baking powder, baking soda, cinnamon, and salt. Gently fold the dry ingredients into the yam mixture, mixing just until incorporated. Fill the paper liners two-thirds full with the batter.",
      "Step 4\nBake in the preheated oven until a toothpick inserted into the center of a cupcake comes out clean, about 17 to 20 minutes. Let cupcakes cool in the pans for 5 minutes, then transfer to a wire rack to cool completely.",
      "Step 5\nBeat cream cheese and butter until fluffy. Add vanilla extract and confectioners' sugar, and mix until smooth. Spread the frosting on the cooled cupcakes."
    ],
    "notes_ingredients": null,
    "notes_instructions": null
  }
]
This article mainly talks about the importance and potential of Bitcoin. It is a digital currency that allows assets to be exchanged between parties without prior trust. Its value is directly based on the usage and speed of the payment system, as well as speculation on future usage. The use of Bitcoin can solve many problems, such as content monetization, combating spam, public payments, etc. While Bitcoin has faced regulatory issues and criticism, it still holds great potential to reimagine how the financial system works in the Internet age. Bitcoin is a network effect, and as more people use it, its value continues to increase, attracting more users. All four parties (consumers, merchants, miners, and developers/entrepreneurs) are expanding the value of Bitcoin, with developers and entrepreneurs playing a particularly important role.

Bitcoin solves the problem of high fees in the traditional financial system by reducing transaction fees. Transaction fees in the traditional financial system are usually 2% to 3%, and Bitcoin is the first Internet payment system that can realize transactions with no fees or very low fees (even a few cents). This makes Bitcoin a more convenient and affordable means of payment for those who do not have a traditional bank account or live in poor countries. In addition, Bitcoin can also solve the problem of high fees in the traditional financial system through micropayments (i.e., ultra-small payments). In the traditional payment system, micropayment has not been realized due to the limitation of the fee structure. However, Bitcoin has the characteristics of infinite segmentation, which can realize any small payment, thus providing the possibility of micropayment.

The future of Bitcoin is very promising. As more and more consumers and merchants begin to use Bitcoin, its usage and the number of users is growing. All four parties involved in Bitcoin (consumers, merchants, miners, and developers/entrepreneurs) play an important role in expanding the value of the entire system, especially developers and entrepreneurs. The network effect of Bitcoin is also increasing, the more people use Bitcoin, the more valuable it is to each user and the more attractive it becomes, thus attracting more people to start using it. Bitcoin also has many potential uses, such as solving the problem of "unbanked" people paying high fees, and enabling micropayments. Although the overall scale of Bitcoin is still very small, its use and convenience are constantly improving, and its future development prospects are worth looking forward to.
Goal
    Traduire toutes les valeurs textuelles présentes dans une liste d’objets d’une recette de cuisine de en (ISO 639) vers es (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 es.
    - 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 : es (ISO 639)
    Données à traduire :

    [
  {
    "recipeCode": "f9c0b729fc224289848aa5b1ac21d684",
    "updated": "2025-05-07T09:50:57.155Z",
    "title": "Spaghetti",
    "subtitle": null,
    "description": "Feeling puzzled like Linguini? Try making spaghetti! Linguini is a character known for being confused or anxious, and his hair resembles spaghetti or noodles. While understanding Linguini might be tricky, following a simple spaghetti recipe is straightforward. Let's begin.",
    "ingredients": [
      {
        "section": "For the recipe",
        "ingredients": [
          "pasta",
          "carrot",
          "green bell pepper",
          "oregano",
          "red chili flakes",
          "fresh cream",
          "salt",
          "olive oil"
        ]
      },
      {
        "section": "Sauce for the pasta",
        "ingredients": [
          "tomatoes",
          "finely chopped garlic",
          "onion",
          "basil leaves",
          "olive oil",
          "salt",
          "pepper"
        ]
      }
    ],
    "instructions": [
      "Boil the pasta in salted hot water.",
      "After boiling, drain the pasta and rinse it with cold water.",
      "Toss the pasta with a little olive oil and set it aside.",
      "To prepare the sauce, add halved tomatoes to a pressure cooker.",
      "Once the tomatoes are cooked, allow them to cool.",
      "When cooled, the tomato skins should begin to loosen; remove the skins.",
      "Blend the peeled tomatoes into a smooth paste in a mixer.",
      "Let the tomato paste rest briefly.",
      "Heat olive oil in a saucepan. When warm, add garlic and onion.",
      "Once the garlic and onions are cooked, add the tomato paste, basil leaves, chili flakes, oregano, salt, and pepper.",
      "Simmer the mixture gently for 3 to 4 minutes.",
      "Add the spaghetti to the tomato sauce.",
      "At this point, add the fresh cream and mix gently over high heat until the spaghetti is evenly coated with the sauce.",
      "Your spaghetti is now ready to serve."
    ],
    "notes_ingredients": null,
    "notes_instructions": null
  }
]
Goal:
You are a world-class expert in culinary recipe classification. Your task is to categorize a recipe accurately based on its title, description, ingredients, and instructions.

Context:
A recipe can either be a beverage or a food item. If it's a beverage, classify it as "drinks". If it's food, choose the most appropriate category among the following:

"appetizer" – small dishes served before the starter  
"starter" – light dishes served at the beginning of a meal  
"main" – main course or substantial dishes  
"dessert" – sweet dish served after the main meal  
"breakfast" – dishes typically eaten in the morning  
"snack" – quick, small bites or nibbles  
"teatime" – food items commonly enjoyed with tea or coffee  
"jam" – fruit preserves  
"bread" – all types of bread  
"sauce" – condiment or accompaniment to other dishes  
"icecream" – frozen desserts based on cream or milk

Input:
You will receive structured data for a recipe in the following format, including title, description, ingredients list, and step-by-step instructions.

json
{"title":"Canadian Goose Roast of Ygritte's Favorite Goose Fletched Arrow ","description":"Ygritte belongs to the Free Folk but is a member of Rattleshirt's war band. She is beautiful, slim, and well-toned. She\ndisplays excellent skills with ax and bone dagger but is very stubborn. This unconventional beauty loves to use the\ncurved bow of the horn with arrows that are adorned with pale goose feathers. This goose recipe is a complete meal.\nThe apples compliment the meat, and their amalgamation brings out the best flavors. It's so fresh in taste that you can\neven have it for breakfast. Takedown this pleasing recipe and start your day on a healthy note.","ingredients":[{"section":"For the recipe","ingredients":["1 tsp. salt and pepper","1 onion thinly sliced","4 duck breasts","2 tbsp. honey","2 apples thinly sliced","2 tbsp. cinnamon powder","2 tsp. olive oil"]}],"instructions":["1. Sprinkle the seasonings on the duck breasts.","2. Sauté the apples in olive oil.","3. Drizzle it with honey and cinnamon powder and sauté till they turn brown.","4. Sauté the duck breasts on a skillet until they become crisp.","5. Remove them and sauté the onions till they turn brown.","6. Add in the apples and honey and cook it for another 2 mins.","7. Finish the cooking by placing them in an oven at 200 degrees F."]}

Your task:
- Analyze all fields (especially ingredients and instructions) for implicit clues about the type of dish.
- Avoid over-relying on the title alone.
- Choose the **most precise and relevant** category from the list.
- Always prefer specificity over generalization.

Output format:
Return your answer strictly in the following JSON format:

json
{ "data": "<category>" }
Send only episode number from below text like 01, 02, 03.etc without any extra text.

[Toonworld4all] Attack on Titan S02E04 480p AMZN WEB-DL Multi Audio ESub.mkv
Assistant: Hello! How can i help you today?
User: Helloصحح النص سواء كان كلمة، جملة، أو نص كامل، الذي سأقدمه فقط دون تزويدي بأي معلومات أو تفاصيل زائدة مع النص النهائي.
 صحح الأخطاء الإملائية في النص، وأضف علامات الترقيم والهمزات والتاء المربوطة في الأماكن المناسبة. (ar).
Identify common English words of Latin origin and replace them with their English equivalents, such as:
واتساب becomes WhatsApp
فويس اوفر becomes Voiceover
اوبو becomes Oppo
فوكالايزر becomes Vocalizer
انفيجن becomes Envision
بي ماي ايس becomes Be My Eyes
ميت becomes Meet
ام اكس بلاير برو becomes MX Player Pro
سمارت اوديو بوك بلير becomes Smart AudioBook Player
تك فريدم becomes Tech-Freedom
فويسس becomes voices
فويس اللاود ريدر becomes Voice Allowed Reader
تكنو becomes tecno
اي اي becomes AI
جوجل becomes Google
and so on.
Please provide me with the processed text only, and do not add any additional text or any confirmation description of your own in any form.
This is the text:
اعتذر لحضراتكم لان درجه الحراره مرتفعه
Assistant:
write arudino for example
idejome labai daug darbo i musu main city ir dar liko nemazai padaryti ir cia tik pradzia :) translate it to english
Assembling the Cast: Highlight the casting process for 1950 movie Winchester '73, revealing how each key actor was chosen for their role. Share insights into the auditions, chemistry tests, and the pivotal moments that defined the casting.

        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.}
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:

فهمت الفازة آما تويكا هاذاك اش قإلي قإلي لازم تهزله الكرهبة مش المشكلة في المفتاح هي
For the Cost down on part (price quoted by Q Plas due to Flex) on 11.03.24 I sent the credit note without a signature pdf copy to Mr. Keith, but after that no further updates on that. I re-attached the same Credit Note for your reference.  rewrite
How would I make a script that removes the movement button and jump button on roblox?
Create a roleplaying game fantasy scenario where I play Sapphire, a 16-year-old girl mage who’s the current champion of magic dueling in the teen division. 10-year-old Lily is challenging me to a match and I accept. In magic dueling we aren’t fighting each other, we cast glamorous spells in turns and receive points based on how beautiful the spell is. A spell can’t be cast more than once in a duel. There are 5 rounds. Tell me my spellcasting stats, which should be higher than Lily’s because I’m 6 years older than her. Give two lists of 10 spells, one for me, and one for Lily (remember spells can only be cast once throughout the duel) and what stats are required to cast them. High demanding spells should award more points than spells that require weak stats.

But for her first spell, Lily casts a powerful rare spell called Infernal Punishment, a visually impressive spell, but one that can also regress the age of a youth back to early childhood, so now I’m physically regressed back to the age of 6, which drastically reduces my stats and my only available spells are baby spells, and my previously strategic mind is now hindered by childish inclinations and urges. Can I still win the duel now that Lily’s the more experienced mage?
Make the scenario difficult for me to win. On a difficulty scale of 1 to 10, make it a 10 (hardest mode).

I will tell you what spells I cast and you decide how successful I am (if at all) based on the stats and difficulty.
Only I decide what spells Sapphire casts. You decide spells for Lily. Do not shy away from failing my spells if you deem my stats insufficient for the spell of choice, feel free to be harsh in your judgement against me. Keep track of points earned. Failure to properly cast spells or bad spells will deduct points.

Provide narration for what spells looks like, the initial regression, and how Lily and I handle ourselves in the duel.
Error: Cannot resolve custom syntax module "postcss-scss". Check that module "postcss-scss" is available and spelled correctly.

Caused by: Error: stylelint tried to access postcss-scss, but it isn't declared in its dependencies; this makes the require call ambiguous and unsound.

Required package: postcss-scss
Required by: stylelint@npm:15.6.2