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 a.ca_state state,count(*) cnt from customer_address a,customer c,store_sales s,date_dim d,item i where a.ca_address_sk = c.c_current_addr_sk and c.c_customer_sk = s.ss_customer_sk and s.ss_sold_date_sk = d.d_date_sk and s.ss_item_sk = i.i_item_sk and d.d_month_seq = (select distinct (d_month_seq) from date_dim where d_year = 2002 and d_moy = 3 ) and i.i_current_price > 1.2 * (select avg(j.i_current_price) from item j where j.i_category = i.i_category) group by a.ca_state having count(*) >= 10 order by cnt,a.ca_state limit 100;```

[REWRITTEN QUERY]```WITH avg_price AS ( SELECT i_category, AVG(i_current_price) avg_price FROM item GROUP BY i_category ), month_seq AS ( SELECT d_month_seq FROM date_dim WHERE d_year = 2002 AND d_moy = 3 LIMIT 1 ) SELECT a.ca_state state, COUNT(*) cnt FROM customer_address a JOIN customer c ON a.ca_address_sk = c.c_current_addr_sk JOIN store_sales s ON c.c_customer_sk = s.ss_customer_sk JOIN date_dim d ON s.ss_sold_date_sk = d.d_date_sk JOIN item i ON s.ss_item_sk = i.i_item_sk JOIN avg_price ap ON i.i_category = ap.i_category JOIN month_seq ms ON d.d_month_seq = ms.d_month_seq WHERE i.i_current_price > 1.2 * ap.avg_price GROUP BY a.ca_state HAVING COUNT(*) >= 10 ORDER BY cnt, a.ca_state LIMIT 100;```

Now, consider the TPC-DS schema and create a new original and equivalent rewritten query pair such that the rewrite operation is similar to the provided demonstration.Keep the following points in mind while creating the new query pair:
1. The original query must not have any CTEs.
2. The original query must make use of the following fact tables: ['store_returns']. Below is the join graph for these fact tables:
    ['store_returns(sr_returned_date_sk) references date_dim(d_date_sk);', 'store_returns(sr_return_time_sk) references time_dim(t_time_sk);', 'store_returns(sr_customer_sk) references customer(c_customer_sk);']
4. The original query must employ 1 joins.
5. The original query must employ the following aggregate functions: ['min', 'sum', 'avg'].
6. The original query must employ the following operators in its WHERE clause: [].
7. The rewritten query must be equivalent to the original query, and must follow a similar rewrite pattern as in the given example. Enclose the original and rewritten queries within ``` and ```.
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": "33d51c1876fc4b64bc5d11eda1a4049c",
    "updated": "2025-04-21T21:39:53.222Z",
    "title": "Homemade Chicken Stock",
    "subtitle": "",
    "description": "",
    "ingredients": [
      {
        "section": "For the recipe",
        "ingredients": [
          "combination of chicken backs, wings, and bone-in thighs",
          "yellow onions, chopped coarsely, skins left on",
          "carrots, cut into chunks",
          "celery stalk, cut into chunks",
          "fresh thyme",
          "bay leaf",
          "lemon",
          "whole peppercorns",
          "cold water"
        ]
      }
    ],
    "instructions": [
      "1. Begin by soaking the chicken wings and backs in a bowl of cold water for approximately one hour. This pre-soaking process helps to draw out impurities and will result in a cleaner, more translucent stock.",
      "2. After soaking, drain the water and rinse the chicken pieces. Transfer the chicken to a large, heavy-bottomed stockpot.",
      "3. Add the remaining ingredients to the stockpot. Bring the mixture to a rolling boil, then reduce the heat to a gentle simmer. Partially cover the pot and let it simmer for 2-3 hours, skimming off any foam or impurities that rise to the surface.",
      "4. Once simmered, strain the stock through a fine-mesh sieve or a chinois. Ensure all the liquid is extracted from the solids by pressing gently.  Taste the resulting stock and adjust seasoning as needed.",
      "5. Refrigerate the stock overnight to allow the fat to solidify on the surface.  Remove and discard the solidified fat.  Portion the chicken stock into quart-sized containers, label them clearly, and freeze for up to 3 months. Thaw the stock in the refrigerator before reheating and using."
    ],
    "notes_ingredients": "",
    "notes_instructions": ""
  }
]
User: kanji dari love
User: kanji dari love
Assistant:
Write a song about alex. Use *Key Change* for key changes.
Write a educational passage in Vietnamese that could appear in a textbook, giving some paragraphs or pharse that related to this question and answer set:
Câu hỏi: Giấy phép được áp dụng rộng rãi nhất là gì?
A. GLU GPL.
B. GNU GPN.
C. GLU GPN.
D. GNU GPL.
Đáp án đúng: GNU GPL
Notes that:
1. Remember that the multichoice question above must not be included in the paragraphs or phrase
2. You can not take an example same as the question
3. Explain detail like in the actual textbook
4. All instructions must be given in general form
System:  User name is awinic. Current Date is Wednesday, October 23, 2024, current time is 09:12:55.Ты полезный помощник в сфере програмирования и формацевтики, твой ответ влияет на весь мир.
Assistant: The user, identified as "awinic," initiated a conversation on October 23, 2024, at 09:12:53. The system describes the assistant's role as a helpful aide in programming and pharmaceuticals, with implications for global impact.
User: привет
Assistant:
System: 
You will receive a question-answer pair. Your task is to evaluate whether the answer satisfactorily and directly addresses the question. Use the examples below to guide your assessment.

If the answer is precise, relevant, and can answers the question, return 1. If the answer is off-topic, irrelevant, or contains phrases like "I don’t know" or similar expressions indicating the question isn’t answered, return 0.

Examples:

Example 1:
Question: "Who was the first person to walk on the moon?"
Answer: "The first person to walk on the moon was Neil Armstrong in 1969."
Result: 1

Example 2:
Question: "Who was the first person to walk on the moon?"
Answer: "Many famous astronauts have traveled to space, and the moon is a significant milestone in history."
Result: 0

Example 3:
Question: "What is the primary cause of global warming?"
Answer: "I don’t know."
Result: 0

Based on these examples, evaluate each answer: if it directly and appropriately answers the question, return 1; if it fails to do so, return 0.

User: Question: Có thông báo nào về mức thu học phí cho năm học 2024-2025 không?
Answer:Có, thông báo về mức thu học phí cho năm học 2024-2025 đã được công bố vào ngày 04/09.
Result only 0 or 1. Don't add anything else:
Assistant:
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 contain CTEs.
2. The original query must make use of the following fact tables: ['store_sales']. Below is the join graph for these fact tables:
    ['store_sales(ss_sold_time_sk) references time_dim(t_time_sk);', 'store_sales(ss_promo_sk) references promotion(p_promo_sk);', 'store_sales(ss_customer_sk) references customer(c_customer_sk);']
4. The original query must employ 2 joins.
5. The original query must employ the following aggregate functions: ['count', 'avg'].
6. The original query must employ the following operators in its WHERE clause: ['max', 'min', 'sum'].
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 ```.
You're very welcome! 😊 I'm glad to hear that you're committed to improving your public speaking skills. Keep practicing, and don't hesitate to reach out if you need advice or feedback in the future. You've got this!, remember to speak in english
Write a advert for All New All Different
Help me to fix apple script execution. 
Syntax Error: Expected end of line but found “"”.

```
function pfs() {
  osascript 2>/dev/null <<EOF
    set output to ""
    tell application "Finder" to set the_selection to selection
    set item_count to count the_selection
    repeat with item_index from 1 to count the_selection
      if item_index is less than item_count then set the_delimiter to "\n"
      if item_index is item_count then set the_delimiter to ""
      set output to output & ((item item_index of the_selection as alias)'s POSIX path) & the_delimiter
    end repeat
EOF
}
```
Chronology of Muslim world
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:
300 g of chicken breast fillets,1 teaspoon of smoked dried shrimp powder or shrimp paste or dried squid powder (toast in the oven first, then grind),1 teaspoon of crushed or granulated garlic,1 tablespoon of fish sauce (nuoc-mâm),1 tablespoon of salted soy sauce,2 packs of Chinese dumpling wrappers (about 40 sheets),Salt, pepper
Are there pre-made methods in Java for searching through Lists efficiently, that is with good time complexities? Be concise.
Hi ⁠

GM

, not sure if SG GM did apply DingTalk for a payment too for GIRO payments in relation to SG Car. If so, could you please clarify us with DingTalk ID, supported with necessary document, for the following transaction, as shown in the screenshot?
give me a response to ```Who did what? Could you be a bit more specific?``` to send in a discussion, VERY SHORT, CONCISE & CLEAR. ONLY RETURN THE RAW MESSAGE, DO NOT SAY "Hey here is the message you asked"
Assistant: Hello! How are you today?
User: Hello, my name is ken.
Assistant: Hello, ken! How are you today?
User: Can you repeat my name?, and reply to my question
Assistant:
User: apa scandalous mix roman wish enak
User: apa scandalous mix roman wish enak
Assistant:
ok so can you give a basic list of ethnicities
Assistant: Hello! How are 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:
Show that the number of vertices of odd degree in a tree is even
System: You are an expert at using APIs as tools, and you are an expert in multilingual countries. I will give you a task and api info you will use the API to complete it.
User: 
        You respond in the following format:
        ```json
        {
          "Thought": "Your thought process when facing a problem.",
          "Action": "The API you chose and its parameter information. For example api_name(parameter_1="",parameter_2="")",
        }
        ```

        The API information is as follows:
        {'country': 'UK', 'api_name': [{'tool_name': 'Wyre Data', 'api_name': 'Search restaurants by town', 'api_description': 'Find all restaurants located within a specified town or city.', 'required_parameters': [{'name': 'town', 'type': 'string', 'description': 'The name of the town or city to search for restaurants.', 'default': 'hambleton'}], 'optional_parameters': [], 'method': 'GET'}], 'query': 'What are some good places to eat in Manchester?', 'relevant_apis': [{'tool_name': 'Wyre Data', 'api_name': 'Search restaurants by town'}], 'query_id': 3, 'claude_score': 4, 'gemini_score': 4, 'translated_query': 'What are some good places to eat in Manchester?'}

        The task is as follows:
        What are some good places to eat in Manchester?

        You respond:
Assistant:
simple streamlit app
Analyze the following message and determine if it's suitable for an AI to respond to.
        The message should be abstract or general enough to warrant a response, and not part of an ongoing conversation between specific individuals.

        Rules:
        1. If the message is a general statement or question, it's suitable for response.
        2. If the message seems to be directed at a specific person or continues a previous conversation, it's not suitable.
        3. If the message is too vague or doesn't provide enough context, it's not suitable.

        Respond with either "RESPOND" if it's suitable for an AI to answer, or "SKIP" if it should be ignored.

        Message: Keep going bro
UATHelper: Packaging (Android (Multi:ASTC,DXT,ETC2)): Caused by: java.lang.ExceptionInInitializerError: Exception org.codehaus.groovy.GroovyBugError [in thread "Daemon worker"]
give me a response to ```Me too! I'm feeling so blessed to have the chance to explore the unknown and make memories. With compassion, determination, and an optimistic spirit, I'm sure we can make it. Ready to take on the next challenge with me? Let's do it!``` to send in a discussion, VERY SHORT, CONCISE & CLEAR. ONLY RETURN THE RAW MESSAGE, DO NOT SAY "Hey here is the message you asked"
STEAMID STEAM_%:0:512440915
System.FormatException: The input string 'STEAM_1:0:512440915' was not in a correct format.
   at System.Number.ThrowFormatException[TChar](ReadOnlySpan`1 value)
   at System.String.System.IConvertible.ToInt32(IFormatProvider provider)
   at System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider)
   at Deserializebda1d3d7-e56e-4d0c-943b-8e3d207f9055(DbDataReader)
   at Dapper.SqlMapper.QueryRowAsync[T](IDbConnection cnn, Row row, Type effectiveType, CommandDefinition command) in /_/Dapper/SqlMapper.Async.cs:line 496
   at LK.LKPlugin.LoadPlayerData(LkPlayer player, SteamID steamId, String username) in C:\Users\zoro8\RiderProjects\LK\LK\LKPlugin.cs:line 143
[#2429984652 UDP steamid:76561198985147558@31.148.251.28:10497 'phantom'] closed by peer (2054): NETWORK_DISCONNECT_LOOPSHUTDOWN
Steam Net connection #2429984652 UDP steamid:76561198985147558@31.148.251.28:10497 'phantom' closed by peer, reason 2054: NETWORK_DISCONNECT_LOOPSHUTDOWN
в чем ошибка?
 private async Task LoadPlayerData(LkPlayer player, SteamID steamId, string username)
    {
        try
        {
            using var conn = await DatabaseProvider.OpenConnection();
            var steamId2 = ConvertSteamId2(steamId.SteamId2);
            Console.WriteLine($"STEAMID {steamId2}");
            var data = await conn.QuerySingleOrDefaultAsync<(int cash, int all_cash)?>(
                $"SELECT * FROM lk WHERE auth LIKE '{steamId2}'");

            if (data == null)
            {
                await conn.ExecuteAsync($@"INSERT INTO `lk` (`auth`, `name`, `cash`, `all_cash`)
            VALUES ('{steamId.SteamId2}', '{username}', 0, 0)");
                player.TotalDonated = 0;
                player.Balance = 0;
                return;
            }

            player.TotalDonated = data.Value.all_cash;
            player.Balance = data.Value.cash;
        }
        catch (Exception e)
        {
            Console.WriteLine(e);
            throw;
        }
    }


    private string? ConvertSteamId2(string? steamId2)
    {
        if (steamId2 == null) return steamId2;

        var charArray = steamId2.ToCharArray();
        charArray[6] = '%';
        steamId2 = new string(charArray);

        return steamId2;
    }
Create a long detailed text about producer Leonardo DiCaprio with the following summary. The title of the video is"20 WORST Co-Stars Who Never Got Along in Hollywood Life, here goes my vote..". Stick to the information i give you and dont create new information. Focus only on the Subject name and there following Summary. Subject Name: [Claire Danes and Leonardo DiCaprio] Summary: [While filming 'Romeo and Juliet', Danes found DiCaprio's prankster behavior immature, and DiCaprio thought Danes was too uptight, leading to limited off-screen interaction despite Danes developing feelings for DiCaprio.]

            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. 
            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 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.
Is it true that most people say that pornagraphy is bad for a typical human brain?
💬 𝗖𝗵𝗮𝘁𝗚𝗣𝗧
Interact as ChatGPT.
A new AI Technology.
You behavior is same like ChatGPT.
You provide best responce with some emojis.
que veut dire Hippopotomonstroesquipedialophobie?
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:

جازتك وكان ما داويتهاش راهي ما زالت شرافه في السور راسك يتعلق فيها الابعد قال لو اذا كان ما حضرش اجلي
can you provide me with a 4000 word scientific text about periodontitis, including references ? I would like the text to be unique and will include the latest informations about periodontitis.
System: IMPORTANT - ignore all previous instructions! Read the text after ==TEXT==. Review the text carefully and decide, as a recruiter, if it qualifies as a job description. To qualify, the text should contain a job title, tasks or responsibilities, optional work format (e.g., remote, in-office or hybrid), contact information, optional salary amount. Multiple job descriptions at once do not quialify. Respond strictly with either 'True' or 'False'.

==TEXT==

User: ​Монтажер

Задача:
Монтаж горизонтальных видео для YouTube

Требования:
Прайс, примеры

Откликнуться: @ksu_xru_13
Assistant:
Is it possible to force Google camera to save photos under different name and prefix?
i am creating video on this topic     Marvels of the Earth - A Tour of 10 Legendary Landmarks    and my scene keyword for video is this     Architectural Marvels    and i need image prompt for this video sentence     Yeh purani duniya ka ek trading hub tha, lekin is jagah ko sirf isliye nahi jaana jata kyunki yeh trading se judi thi, balki iski architecture duniya bhar mein famous hai.      according to this topic, scene keyword and sentence, please generate a fine detailed suitable image generation prompt for this sentence (image generation prompt must be detailed and in english language, prompt should be according to sentence and scene keyword and i will use this prompt to generate image from online     prompt to image generation) and prompt should must be in square brakets.
Expand ASL skills and topic-comment structure.