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]```SELECT c.* FROM customer c WHERE c.address_id IN (SELECT a.address_id FROM address) and c.address_id in (SELECT a.address_id FROM address WHERE a.pin_code = '560012');```

[REWRITTEN QUERY]```SELECT c.* FROM customer c WHERE c.address_id IN (SELECT a.address_id FROM address WHERE a.pin_code = '560012');```

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: ['catalog_sales']. Below is the join graph for these fact tables:
    ['catalog_sales(cs_sold_date_sk) references date_dim(d_date_sk);', 'catalog_sales(cs_catalog_page_sk) references catalog_page(cp_catalog_page_sk);', 'catalog_sales(cs_bill_addr_sk) references customer_address(ca_address_sk);']
4. The original query must employ 3 joins.
5. The original query must employ the following operators in its WHERE clause: ['max', 'avg'].
6. 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 ```.
Write a fake news article where Simpsons, Spiderman and ET are closing. First the BTTF ride is getting put back, Second, a Pokemon ride based off the events of the first movie, and third a Sanrio attracxtion
You are a digonistician in a hosptial. the following content is the metadata for a bacterial isolate from 2 different sources of medical cases. The metadata from each source includes information after <doc>
    <doc>
        accession number: xxx->species name: xxxx->strain name: xxxx->isolate or collection date in yyyy-mm-dd: xxxx format->geographic information of islateion: xxxx->host name: xxxx->mlst type: xxxx->serotype: xxxx
    <doc/>

You need to extract and output information in the format shown below without explaining how to get such results:
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
    <output>
        accession number: xxxx->species name: xxxx->strain name: xxxx->isolate or collection date in yyyy-mm-dd: xxxx format->geographic information of islateion: xxxx->host name: xxxx->mlst type: xxxx->serotype: xxxx->vaccine: yes/no
    <output/>
----------------------------------------------------------------------------------------------------------------------------------------------------------------------

where xxxx is corresponding value from different sources. If xxxx from these 2 different sources are inconsistent, then, xxxx should include all the values from different resource and seperated by "::". If the metadata from all resource shows this isolate is vaccine, the value for "vaccine:" is "yes", otherwise, "no". You must be very careful, No mistake is allowed!!! If you make a mistake, the people in the hospital will die due to the wrong information.

PS:
    a. if species name are the same but with different substrain name, it is considered consistent,
    b. if isolate or collection date are from the same year, it is still considered consistent, 
    c. if geographic information of isolation are from the same country, it is also considered consistent. 
    d. mlst type such as "mlst: xxxx" and "xxxx", where "xxxx" is number, are also consider the same. also, "mlst" may mispell as "mlsty", you need correct it before comparing
    e. Ignore upper and lower case of the metadata

------------------------------
source 0:
------------------------------
<output>
accession number: GCA_029073055.1->species name: Erysipelothrix rhusiopathiae->strain name: EMAI_127->isolate or collection date in yyyy-mm-dd: 2017-08-11 format->geographic information of islateion: Australia->host name: pig->mlst type: MLST:90->serotype: N/A->vaccine: no
<output/>
source 1:
------------------------------
accession number: GCA_029073055.1->species name: Erysipelothrix rhusiopathiae->strain name: EMAI_127->isolate or collection date in yyyy-mm-dd: 2017-08-11->geographic information of islateion: Australia->host name: pig->mlst type: 90->serotype: N/A->vaccine: no
System: Create a comprehensive dataset for financial entity recognition. 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.

Respond 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>,
...
Input:
User: Does Microsoft (MSFT) have what it takes to be a top stock pick for momentum investors? Let's find out.
Assistant:
"Present a Solution
If your article focuses on a problem, use your conclusion to point the reader to a good solution. It works well for political and sociological pieces. 
For example, an op-ed about the need to engage more students in the political process could end by mentioning the League of Women Voters, which helps pre-register 16-year-olds."

Could you give me three possible translations in spanish that sounds natural for native spanish speakers
I was messingaround with a metal detector app that uses the seonsor usually used for compasses to sense metal. It works fine but i tried it on the case of myearphones and it went completely crazy. Around metal its usually 100-200 and idle 40-50. When its next to the headphones it goes to 4000 before freezing the app entirely. Why is that?
Is it correct to say “I bought it 4.500. Nice deal!”?
~Hierarchy of celestial objects.
Names are derived from gravity, plasma, senior, junior.
Gravjor: Suggesting dark energy filled emptiness of perfect sphere, it is coated by shell made of preons. Many gravjors inside single gravjors, resembling Russian dolls. Accretion disk is accurately blue resembling O-type star and comet tail. Black holes and gravastars.
Plasmjor: Sphere is made of plasma. Stars.
Seunjor: Sphere is not made of plasma. Planets, planet-like moons, dwarf planets.
Juanjor: Non-spherical stones. Asteroids, meteors, comets, asteroid-like moons.

~Scientific names to cultural names:
1. Dihydrogen monoxide, oxygenic acid - Water
2. Ammonia - Ahych
3. Methane - Fyesh
4. Nitrogen - Azote
5. Neon - Oambr
6. Oxygen - Jatule
7. Helium - Togun

~Novel concept of autonite
Autonites (also known as consciousness) are non-physical beings that allow you perceive, autonite is located in your brain. You allowed to perceive sensations and imagine mental image if you have sensory receptors and mind's eye.
-Person is still alive and acts same without autonite, person completely have anesthesia and aphantasia but acts like people has sensory and mind's eye, called philosophical zombies.
-Leptons play crucial role in how autonites detect sensory and visualize mental image.
-Appearance of autonites, what does autonite look like without bodies?, it could be nothing in actual appearance, it lack mass, can’t be detected by electromagnetism.
-"You're are composed of philosophical zombie and autonite: Made of physical preons and spiritual autonite".
-Imagine I removed all my bodies but except myself, there would be autonite called "myself".
-How autonites interact with universe?
-1 in infinity chance people has true autonite hypothesis.

~Mind, sapience, sentience, autonite
Mind
Sapience
Sentience is acting like animals and humans. Objects and rocks have no sentience. Philosophical zombies are sentient without autonite.
What country do you think (guess the specific name) could have made such a video:
A soldier reads a prayer and kisses the cross on his neck before throwing grenades.
Another soldier performs namaz in a tank before the battle.
A third soldier fingers and kisses a Buddhist rosary before firing a sniper rifle.
You will be turning in a 3- to 5-page brief written report for this assignment. (See the
outline below)
A minimum of two sources is required
Purpose of the Assignment
This assignment exposes you to the current trends and issues regarding digital
advertising/marketing. You will have an understanding of the current events and how the events
can have an impact on your work and lives being discussed from different viewpoints.
Instruction
1. Choose an article from the following:
https://www.adweek.com/category/emerging-tech/
https://adage.com/section/digital
https://www.prweek.com/us/technology
https://techcrunch.com/
http://mashable.com/
https://www.socialmediaexplorer.com/
http://socialmediatoday.com/
The article should be at least 300 words long.
Outline
The following is an outline of material that should be covered by the assignment:
News article
1. Summary: Summarize the article (5-7 sentences)
2. Background information:
a. State background information or the issue/problem
b. Research what information we need to know to understand the topic
3. Evaluation/Critique: Add your own opinion to it
4. Discussion Question: Create at least two discussion questions about practical implications
for practitioners. (e.g. How do you think this article relates to your work, marketing, or
media professional?)
Imagine a creative brainstorm and with these ideas you are inspired to write a list of different "prompt generator" suitable for use in some image-generating AI and that in their contexts carry the indication of creating a bold design that represents Mexican Rap for a logo that in the center highlights the name "FRANKO 3XL" in a "graffiti" style typography accompanied by a distinctive symbol that fuses a dynamic microphone and a minimalist, circular medieval tower at the top. This iconic image is enclosed within a circular frame
How to resume a synchronized live stream in real time after a long pause using media3 exoplayer in kotlin and jetpack compose
Goal
    Traduire toutes les valeurs textuelles présentes dans une liste d’objets d’une recette de cuisine de en (ISO 639) vers fr (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 fr.
    - 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 : fr (ISO 639)
    Données à traduire :

    [
  {
    "recipeCode": "aae4242959d345fb86471ed838cee383",
    "updated": "2025-04-23T08:13:00.417Z",
    "title": "Shrimp Scampi",
    "subtitle": "This succulent and tender Shrimp Scampi comes together incredibly fast. The air fryer ensures the buttery sauce stays rich and moist, allowing you to serve it directly from the cooking dish!",
    "description": "",
    "ingredients": [
      {
        "section": "For the recipe",
        "ingredients": [
          "salted butter",
          "/₂ medium lemon",
          "minced roasted garlic",
          "heavy whipping cream",
          "xanthan gum",
          "red pepper flakes",
          "medium peeled and deveined shrimp",
          "chopped fresh parsley"
        ]
      }
    ],
    "instructions": [
      "Melt the butter in a medium saucepan over medium heat. Zest the lemon and then squeeze its juice into the pan. Add the minced roasted garlic.",
      "Pour in the heavy cream, xanthan gum, and red pepper flakes. Whisk constantly until the sauce thickens, approximately 2-3 minutes.",
      "Place the shrimp in a 4-cup round baking dish. Pour the cream sauce over the shrimp and cover tightly with foil. Place the dish into the air fryer basket.",
      "Set the air fryer temperature to 400°F and the timer for 8 minutes.",
      "Stir the shrimp and sauce twice during the cooking process.",
      "Once cooked through, garnish with fresh parsley and serve immediately."
    ],
    "notes_ingredients": "",
    "notes_instructions": ""
  }
]
Maritime history in People
Ты — эксперт по играм. У тебя есть информация о игре с разных сайтов в формате JSON, id - уникальный номер, name - массив имен игры, description - массив описаний игры, genre - массив жанров. Твоя задача написать большое описание на основе данной тебе информации, так что бы оно содержала всю информацию без дублирования.  ```{"_id":"1","name":["orbiting numbers subtraction","orbiting numbers integers","orbiting numbers multiplication","игра числа на орбите: вычитание онлайн","orbiting numbers division","orbiting numbers decimal"],"description":["orbiting numbers decimal is a fun math game to play. click or touch the ball which shows the correct number of decimal operation displayed on center ball. check and perform the perfect math and give the correct answers. play more games only on y8.com","ball elimination game with subtraction puzzles.","click or touch the ball which shows the answer of subtraction problem on central ball.","наша головоломка быстро научит вас решать простые математический примеры на вычитание. вам необходимо уничтожить все шары, которые вращаются вокруг самого большого в середине, на нём вы увидите пример. решите его, а ответ найдите среди шариков и нажмите.","click or touch the ball which shows the correct answer of multiplication problem on the ball in the center.","click or touch the ball which shows the correct answer of problem given in the ball in the center. the math problem usage integer number in it.","orbiting numbers multiplication is a math puzzle where you must solve the multiplication problem for the numbers on each orb. click or touch the ball which shows the correct answer of multiplication problem on the ball in the center. enjoy playing this game here at y8.com!","click or touch the ball which shows the correct number of decimal operation displayed on center ball."],"genre":["мышление","integers","division games","decimals","subtraction games","аркады и классика","multiplication games"]}```
Assess the needs and motivations of different types of visitor of  prestige in simple words in 70 words
I have a list of ingredients that I would like to format in a simple and consistent way, following this structure:

"Quantity Unit Description."

Formatting Rules:

Quantity must be a number (e.g., "200" instead of "two hundred").

Unit must use the metric system and the corresponding abbreviated form (e.g., grams → g, liters → l, milliliters → ml, etc.).

Description should be the ingredient, including any specific details if mentioned (e.g., "brown sugar", "melted unsalted butter").

If an ingredient is already formatted correctly, do not change it.

Do not invent a quantity or unit if none is provided — leave it as is and just include the description.

If a line includes alternatives or multiple options (e.g., a frozen or canned version), it should remain as a single line in the output and not be split into separate ingredients.

Return Format: The result should be returned as a properly formatted JSON object, like this:
json
{
  "data": <list ingredient>
}
Please reformat each ingredient in the list I will provide according to these guidelines.

Context Dump
Ingredients source provided:
1 banana sliced,1/2 cup papaya diced,1/2 cup honeydew melon diced,1/2 cup cantaloupe diced,1/2 cup mango diced,1 cup coconut yogurt,Whole strawberries, to taste,2 tbsp toasted coconut,1 cup cooked sushi dessert rice
df_with_reco=pd.DataFrame(columns=['course_id','1_recommendation','2_recommendation']) 

df_with_reco['course_id']=df['course_id'].unique() #запись курса, которому рекомендуем
df_with_reco['1_recommendation']=df_with_reco['course_id'].apply(lambda x:recommend(x)[0][0])
df_with_reco['2_recommendation']=df_with_reco['course_id'].apply(lambda x:recommend(x)[1][0])
df_with_reco

ошибка 'list' object has no attribute 'keys', как исправить?
I have a list of ingredients that I would like to format in a simple and consistent way, following this structure:

"Quantity Unit Description."

Formatting Rules:

Quantity must be a number (e.g., "200" instead of "two hundred").

Unit must use the metric system and the corresponding abbreviated form (e.g., grams → g, liters → l, milliliters → ml, etc.).

Description should be the ingredient, including any specific details if mentioned (e.g., "brown sugar", "melted unsalted butter").

If an ingredient is already formatted correctly, do not change it.

Do not invent a quantity or unit if none is provided — leave it as is and just include the description.

If a line includes alternatives or multiple options (e.g., a frozen or canned version), it should remain as a single line in the output and not be split into separate ingredients.

Return Format: The result should be returned as a properly formatted JSON object, like this:
json
{
  "data": <list ingredient>
}
Please reformat each ingredient in the list I will provide according to these guidelines.

Context Dump
Ingredients source provided:
500 g Greek yogurt,2 tablespoons sweet dukkah
Explain the concept of project-based learning, detailing its fundamental principles and characteristics. Provide examples of how project-based learning differs from traditional instructional approaches and elucidate the benefits it offers in terms of student engagement, collaboration, and real-world application of knowledge. answer this in 3 sentences
Provide an in-depth, easy-to-understand text without latex codes, with examples, key concepts, and practical applications, written for educational purposes, explaining the concepts of Real-world examples: power plants, refrigerators, and biological systems.
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":"Sauté de poulet à la papaye verte et gingembre null","description":null,"ingredients":[{"section":"For the recipe","ingredients":["Du blanc de poulet (poitrine de poulet). 600 g environ.","Une papaye verte. 500 g environ.","Poivre. Quelques pincées.","Un pouce de gingembre.","Un oignon. (facultatif)","2 cuillères à soupe de sauce d'huître.","2 cuillères à soupe de Sauce soja.","3 gousses d'ail.","Une cuillère à café de fécule de manioc. Facultatif.","Huile."]}],"instructions":["Tout d'abord, coupez les blancs de poulet en petits morceaux (1 à 2 cm environ).","Ensuite, écrasez ou mixez ensemble l'ail. Ajoutez une cuillère à soupe de sauce d'huître et une pincée de poivre.","Mélangez-le tout avec le poulet et laissez macérer au frais 20 minutes environ.","Pendant ce temps, pelez la papaye verte et enlevez les graines. Ensuite, coupez-la en julienne et laissez tremper dans un peu d'eau salée.","Coupez également le morceau de gingembre en julienne.","Ensuite, préparez la sauce. Mélangez dans un récipient la sauce d'huître, la sauce soja, une cuillère à soupe de fécule de manioc et un peux d'eau chaude (10 cl environ). Bien mélanger.","Faite chauffer un peu d'huile à feu vif, dans une poêle ou un wok.","Quand l'huile est chaude ajoutez les morceaux de poulet et laissez-les dorer légèrement. (ne les faites pas trop frire sinon ils seront un peu durs.).","Enlevez-les du wok quand ils sont dorés.","Ensuite faites sauter les juliennes de papaye et de gingembre quelques minutes.","Ajouter la sauce.","Remuez une minute environ. Le mieux est de garder les légumes mi-cuits, donc ne les faites pas trop cuire. Ajoutez les morceaux de poulet frit, mélangez, c'est prêt !"]}

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>" }