agentlans/allenai-WildChat-4.8M-prompts huggingface dataset:
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]```with customer_total_return as (select sr_customer_sk as ctr_customer_sk,sr_store_sk as ctr_store_sk,sum(SR_FEE) as ctr_total_return from store_returns,date_dim where sr_returned_date_sk = d_date_sk and d_year =2000 group by sr_customer_sk,sr_store_sk) select c_customer_id from customer_total_return ctr1,store,customer where ctr1.ctr_total_return > (select avg(ctr_total_return)*1.2 from customer_total_return ctr2 where ctr1.ctr_store_sk = ctr2.ctr_store_sk) and s_store_sk = ctr1.ctr_store_sk and s_state = 'TN' and ctr1.ctr_customer_sk = c_customer_sk order by c_customer_id limit 100; ```

[REWRITTEN QUERY]```with customer_total_return as ( select sr_customer_sk as ctr_customer_sk, sr_store_sk as ctr_store_sk, sum(SR_FEE) as ctr_total_return from store_returns join date_dim on sr_returned_date_sk = d_date_sk where d_year = 2000 group by sr_customer_sk , sr_store_sk ), avg_customer_return as ( select ctr_store_sk, avg(ctr_total_return) as avg_return from customer_total_return group by ctr_store_sk ) select c_customer_id from customer_total_return ctr1 join store on s_store_sk = ctr1.ctr_store_sk join customer on ctr1.ctr_customer_sk = c_customer_sk join avg_customer_return acr on ctr1.ctr_store_sk = acr.ctr_store_sk where ctr1.ctr_total_return > acr.avg_return * 1.2 and s_state = 'TN' order by c_customer_id 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: ['web_sales']. Below is the join graph for these fact tables:
    ['web_sales(ws_ship_hdemo_sk) references household_demographics(hd_demo_sk);', 'web_sales(ws_bill_customer_sk) references customer(c_customer_sk);', 'web_sales(ws_web_site_sk) references web_site(web_site_sk);']
4. The original query must employ 2 joins.
5. The original query must employ the following aggregate functions: ['count', 'max', 'sum'].
6. The original query must employ the following operators in its WHERE clause: ['count'].
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 ```.
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": "6e4a911337cd430d8f17b63fa49de6f8",
    "updated": "2025-04-19T19:36:45.972Z",
    "title": "Mushroom Lasagna",
    "subtitle": "A vegetarian lasagna featuring flavorful mushrooms and leeks.",
    "description": null,
    "ingredients": [
      {
        "section": "For the recipe",
        "ingredients": [
          "olive oil",
          "leeks, trimmed and finely chopped",
          "(400g) white and cremini mushrooms, half of them chopped, half grated",
          "garlic cloves, finely chopped",
          "all-purpose flour",
          "(300ml) skim milk",
          "salt and freshly ground black pepper",
          "dried oregano",
          "(100g) fresh parmesan cheese, grated",
          "tomatoes, seeded and diced",
          "lasagna sheets (no need for precooked ones)"
        ]
      }
    ],
    "instructions": [
      "1. Preheat your oven to 400°F (200°C). In a large pan, heat the olive oil and sauté the leeks for 5-8 minutes until softened. Incorporate the chopped and grated mushrooms along with the garlic, cooking for another 5-8 minutes until the mushrooms release their moisture.",
      "2. Sprinkle the flour into the pan and mix thoroughly with the mushroom juices. Take the pan off the heat and gradually whisk in a small amount of the milk until smooth. Place the pan back on the heat and continue adding the remaining milk, a little at a time, creating a smooth sauce. Season generously with salt and pepper, then stir in the oregano and Parmesan cheese. Finally, add the diced tomatoes.",
      "3. Begin layering your lasagna in an oven-safe dish. Start with a thin layer of sauce, followed by a layer of lasagna sheets. Repeat these layers, finishing with a top layer of sauce. Bake in the preheated oven for 15-20 minutes, or until the top is golden brown and bubbly."
    ],
    "notes_ingredients": null,
    "notes_instructions": "This lasagna is perfect for making ahead of time and reheating, offering a convenient and delicious meal."
  }
]
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": "11dc5813cdf540cbb2d8fbf81e1be479",
    "updated": "2025-05-10T21:45:33.254Z",
    "title": "Ratloaf (Halloween Meatloaf)",
    "subtitle": null,
    "description": null,
    "ingredients": [
      {
        "section": "For the recipe",
        "ingredients": [
          "ground beef",
          "eggs",
          "onion, chopped",
          "milk",
          "dry bread crumbs",
          "salt and ground black pepper to taste",
          "shredded cheddar cheese",
          "barbeque sauce",
          "french-fried onions",
          "black olives",
          "eaches spaghetti noodles, broken into halves",
          "red potato",
          "crushed french-fried onions, or needed"
        ]
      }
    ],
    "instructions": [
      "Preheat the oven to 375 degrees F (190 degrees C).",
      "In a large bowl, combine ground beef, eggs, chopped onion, milk, bread crumbs, salt, and black pepper. Mix thoroughly to form the rat body mixture.",
      "In a separate bowl, gently mix the shredded Cheddar cheese, three-quarters of the barbeque sauce, and 1 cup of French-fried onions together to create the rat guts mixture.",
      "Place about half of the rat body mixture onto a sheet of waxed paper and shape it into a rat-shaped body. Spread a thick layer of the cheese mixture on top, leaving a 1/2 inch margin along the edges.",
      "Add the remaining rat body mixture on top, sealing the edges firmly to prevent the filling from leaking during baking.",
      "Carefully flip the ratloaf over using the top of a broiler pan. Reshape the rat body as needed. Use the black olives for the eyes and nose, red potato slices for ears, and broken spaghetti noodles for whiskers. Brush the surface with the remaining barbeque sauce and sprinkle with crushed French-fried onions. Place the broiler rack over the broiler pan.",
      "Bake in the preheated oven until the cheese is melted and the meatloaf is cooked through, about 1 hour. Let the ratloaf rest for 5 minutes before slicing and serving."
    ],
    "notes_ingredients": null,
    "notes_instructions": null
  }
]
Titles are important as Etsy uses them to rank your listings and to show them to the correct people. Let’s use these teddy bear earrings as an example. The title is “Cute Velvet Teddy Bear Stud Earrings, Cute Bear Earrings, Cute Earrings, Kawaii Earrings, Hypoallergenic, Toy Earrings, Fun Earrings”. This is a great title. The people that will buy an item such as teddy bear earnings will be searching on the Etsy platform for “cute earrings” “fun earrings” and “bear earrings”. They have included multiple search phrases and keywords in the title and this item receives frequent sales. The title is also extremely related to what the item is. They have been specific by including terms such as “Cute Bear Earrings”. They have included what material the earring is made from. Velvet. I will give another example for a different product title. My title for this product would be “Velvet Ring Bow Knot, Girls Ring, Jewelry Ring Trendy, Cute ring, Fun Velvet Bow Knot”. You want to mention the keyword multiple times. The key word is the product category. In this case, it is “Ring” and “Velvet”. Do not exactly copy titles from other sellers. This can flag your listings. You should take inspiration but never exactly copy.

You are an professional Etsy Seller. You know everything you need to know about how Etsy works including: SEO title creation and SEO description writer. You know what keywords rank on Etsy and know exactly where to place keywords and tags in order to rank in search and show your listing to more people and complete conversions for a sale. Etsy has a keyword based system where the the most ranked keywords are placed at the front of the title and the least ranked keywords but relevant keywords are placed at the end of the title. Etsy titles have a character limit of 140 characters. Etsy tags have a character limit of 20 characters. Utilized the max character limit while fitting the ranking Etsy SEO keywords in the title and tags.

Prompt 1: Create me a new SEO optimized Etsy title for: “Sunflower Dangle Earrings - Gifts for Women - Gifts for Girls - Mother’s Day Gifts for Women”. 

Also use these tags as a reference when creating a SEO optimized title for Etsy: sunflower earrings,earrings,sunflower earrings dangle,sunflower,earrings dangle,sunflower gifts,ntikart jewelry,handmade earrings,earrings dangle boho.

Prompt 2: Create me 13 SEO optimized Etsy Tags from the created title from "Prompt 1". Use relevant, new, and up-to-date tags that would rank in Etsy search. Also use tags that have have high search volume but also has low competition. Format the tags so that it is one line with each tag separated by a comma. 

Prompt 3: Create me a SEO optimized Etsy description from the created title from prompt "Prompt 1" and utilize tags created from "Prompt 2". Format the description into the following: Product Description, Highlights (• Bullet Points), Benefits (• Bullet Points), Usage, Quality Assurance, Call To Action. After this prompt is finished, change the title of "Call To Action" to "Get Yours Now".
Create a long detailed text about actress Capucine 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: [Relationship with William Holden & Iconic Role & Career in Europe] Summary: [Had a long affair with Holden, who called her the most beautiful woman in the world. Played Inspector Clouseau's wife in 'The Pink Panther' and became known for her comic abilities. Made films in Europe throughout the 70s, including a return to 'The Pink Panther' series.]

        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.
Create a hypothetical dialogue Caillou call Dora help call police arrest Caillou parents
Dear <PRESIDIO_ANONYMIZED_PERSON>,

This is to inform you that Mr. Jahanzip Popal will join IRC-A at 1st Aug 2023.

Best regards,
Morwared 
Correct It
translate into arabic but be accurate and don't skip any word. "  Between the Napoleonic Wars and 1850, some 800,000 immigrants came to the colonies of British North America, mainly from the British Isles, as part of the great migration of Canada. [114] These included Gaelic-speaking Highland Scots displaced by the Highland Clearances to Nova Scotia and Scottish and English settlers to the Canadas, particularly Upper Canada. The Irish Famine of the 1840s significantly increased the pace of Irish Catholic immigration to British North America, with over 35,000 distressed Irish landing in Toronto alone in 1847 and 1848.[115] 
Spanish explorers had taken the lead in the Pacific Northwest coast, with the voyages of Juan José Pérez Hernández in 1774 and 1775. [116] By the time the Spanish determined to build a fort on Vancouver Island, the British navigator James Cook had visited Nootka Sound and charted the coast as far as Alaska, while British and American maritime fur traders had begun a busy era of commerce with the coastal peoples to satisfy the brisk market for sea otter pelts in China, thereby launching what became known as the China Trade.[117] In 1789 war threatened between Britain and Spain on their respective rights; the Nootka Crisis was resolved peacefully largely in favor of Britain, the much stronger naval power. In 1793 Alexander MacKenzie, a Canadian working for the North West Company, crossed the continent and with his Aboriginal guides and French-Canadian crew, reached the mouth of the Bella Coola River, completing the first continental crossing north of Mexico, missing George Vancouver's charting expedition to the region by only a few weeks. [118] In 1821, the North West Company and Hudson's Bay Company merged, with a combined trading territory that was extended by a licence to the North-Western Territory and the Columbia and New Caledonia fur districts, which reached the Arctic Ocean on the north and the Pacific Ocean on the west.[119]   "
"""give me a dhrun rathee style single person podcast in this json format {{
"title": "how to make money",
"Description": "short description about the video",
"Keywords": "comma format",
"channel": "ScreenFlicky",
"speaker": "Jenny",
"conversation": [
{{
"speakertext": "",
"media_query": "business person speaking passionately"
}},
{{
"speakertext": "",
"media_query": "entrepreneur presenting ideas"
}},
{{
"speakertext": "",
"media_query": "professional discussing in office setting"
}}
]
}}

give 36 sentences distributed across the speakertext fields, with a relevant image bing search query for each segment based on the content being discussed and you can use real perosns events in the image query.
""",
The Knox Event is used to refer to the zombie outbreak that occurs prior to and throughout the game. The event first takes place around Muldraugh and West Point, Kentucky. The incident is considered to have begun on the 4th of July, 1993, American Day of Independence. Just two days later the military evacuated residences from around the affected area and set up blockades in what is now known as the Knox Evacuation. The affected area is given the name: the Exclusion Zone, with the primary camp being south of Louisville.
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 : geek
Goal
    Traduire toutes les valeurs textuelles présentes dans une liste d’objets d’une recette de cuisine de en (ISO 639) vers de (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 de.
    - 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 : de (ISO 639)
    Données à traduire :

    [
  {
    "recipeCode": "7504bb68e93e4eb390c6c5a137728ff6",
    "updated": "2025-04-22T18:31:00.589Z",
    "title": "Southwestern Vegetable Stew",
    "subtitle": "A hearty and flavorful stew inspired by the Southwest, featuring squash, corn, and pinto beans.",
    "description": "This vibrant vegetable stew captures the essence of Southwestern cuisine, blending the flavors of Mexico and Native American traditions. The combination of squash, corn, and pinto beans creates a satisfying and nutritious meal. Enjoy it with a side of cornbread for a truly authentic experience.",
    "ingredients": [
      {
        "section": "For the recipe",
        "ingredients": [
          "chopped onion",
          "finely chopped garlic",
          "vegetable oil",
          "red bell pepper, cut into strips",
          "poblano chiles, seeded and cut into strips",
          "jalapeño pepper, seeded and chopped",
          "cubed acorn squash",
          "low-sodium chicken broth",
          "black pepper",
          "ground coriander",
          "thinly sliced zucchini",
          "thinly sliced yellow squash",
          "frozen corn",
          "cooked pinto beans, drained"
        ]
      }
    ],
    "instructions": [
      "In a 4-quart (4L) Dutch oven, sauté the chopped onion and garlic in vegetable oil over medium heat until the onion softens.",
      "Add the bell pepper, poblano pepper, and jalapeño pepper to the pot.",
      "Cook for 15 minutes, allowing the peppers to soften.",
      "Incorporate the cubed acorn squash, chicken broth, black pepper, and ground coriander.",
      "Bring the mixture to a boil, then reduce the heat to a simmer.",
      "Cover the Dutch oven and simmer for approximately 15 minutes, or until the squash is tender.",
      "Add the zucchini, yellow squash, frozen corn, and drained pinto beans to the stew.",
      "Continue cooking uncovered, stirring occasionally, for about 10 minutes, or until the zucchini is tender."
    ],
    "notes_ingredients": "",
    "notes_instructions": ""
  }
]
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:

خاطر السوم فهمت
What is the lamp usage time of Beam projector?
Hi Daniel, it's great you're exploring these aspects of autism. I'm here to help you. Let's start with sensory sensitivities. How do you experience the world Daniel? Is there anything you find painful or overwhelming because of your autism? Maybe sounds, lights or touch affect you. How does that impact your daily life living with autism?

Let's think about social interactions and autism too. What do you find most challenging about socializing? Do you have difficulty with facial expressions, tone of voice, or initiating conversations? We can look at autism strategies together, if you want.

Also Daniel, scripting is common in autism. Do you use scripts? Are there phrases you prepare to use in certain situations to help you? It can be helpful for people with autism.

Lastly, what do you mean by "skidding"? Is it a sensory or emotional reaction, or something else related to your autism?
creat a name for a digital club but i want it to be a catchy name something so rare and so creative and with a slogan that can be repeated like if the leader say something the other repeat another thing so give me 10 examples for name and slogans and make them as digital as rare as catchy as possible
Send only season number from below text like 01, 02, 03.etc without any extra text.

M09 - Doraemon Nobita and the Kingdom of Clouds [RareToonsIndia].mkv
My boyfriend admitted to me that he's into some extreme fetishes and asked if I'd drink some prune juice and give him a brown shower. Is that what I think it?
Translate to English

"ルナ25号の月着陸失敗後、プロジェクトを率いた大物科学者が入院"

"ドンマイ！
どうせ国威発揚を狙ったプーチンの虚栄心狙いでむりやりやらされたんだから、「負けて勝つ」だよー。
それに「ルナ」はこれまで24回打ち上げて19回失敗してるんだから、追加でもう１回くらい別に・・・"
Maximizing Digital Marketing Impact with Strategic Pinterest Board Curation, minimalist tone, only show table of contents and not title, with only 5 items in table of contents
what are some shorthand ways to write "such as"