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 promotions,total,cast(promotions as decimal(15,4))/cast(total as decimal(15,4))*100 from (select sum(ss_ext_sales_price) promotions from store_sales ,store ,promotion ,date_dim ,customer ,customer_address ,item where ss_sold_date_sk = d_date_sk and ss_store_sk = s_store_sk and ss_promo_sk = p_promo_sk and ss_customer_sk= c_customer_sk and ca_address_sk = c_current_addr_sk and ss_item_sk = i_item_sk and ca_gmt_offset = -7 and i_category = 'Home' and (p_channel_dmail = 'Y' or p_channel_email = 'Y' or p_channel_tv = 'Y') and s_gmt_offset = -7 and d_year = 2000 and d_moy = 12) promotional_sales, (select sum(ss_ext_sales_price) total from store_sales ,store ,date_dim ,customer ,customer_address ,item where ss_sold_date_sk = d_date_sk and ss_store_sk = s_store_sk and ss_customer_sk= c_customer_sk and ca_address_sk = c_current_addr_sk and ss_item_sk = i_item_sk and ca_gmt_offset = -7 and i_category = 'Home' and s_gmt_offset = -7 and d_year = 2000 and d_moy = 12) all_sales order by promotions, total limit 100;```

[REWRITTEN QUERY]```select promotions, total, (promotions / total) * 100 as promotion_percentage from ( select sum(case when p_channel_dmail = 'Y' or p_channel_email = 'Y' or p_channel_tv = 'Y' then ss_ext_sales_price else 0 end) as promotions, sum(ss_ext_sales_price) as total from store_sales join store on ss_store_sk = s_store_sk join promotion on ss_promo_sk = p_promo_sk join date_dim on ss_sold_date_sk = d_date_sk join customer on ss_customer_sk = c_customer_sk join customer_address on ca_address_sk = c_current_addr_sk join item on ss_item_sk = i_item_sk where ca_gmt_offset = -7 and i_category = 'Home' and s_gmt_offset = -7 and d_year = 2000 and d_moy = 12 ) as sales_data order by promotions, total 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: ['catalog_returns']. Below is the join graph for these fact tables:
    ['catalog_returns(cr_returning_hdemo_sk) references household_demographics(hd_demo_sk);', 'catalog_returns(cr_returned_time_sk) references time_dim(t_time_sk);', 'catalog_returns(cr_catalog_page_sk) references catalog_page(cp_catalog_page_sk);']
4. The original query must employ 3 joins.
5. The original query must employ the following operators in its WHERE clause: ['max', 'min'].
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 ```.
Besides DNA methylation, many forms of epigenetics including nucleosome localization, chromatin remodeling, histone modification, RNA variable splicing, non-coding RNA, RNA modification, and pseudogenes have been found (Eichten et al., 2014). Among them, histone modifications have been widely recognized as a dynamic regulator of transcriptional regulation in environmental signal responses, which usually involve acetylation, methylation, phosphorylation, and ubiquitination on lysine or arginine residues at the free N-terminal tail region of histones H3 and H4 (Bannister and Kouzarides, 2011; Suganuma and Workman, 2011). Histone acetylation is mainly catalyzed by histone acetyltransferase (HAT) and histone deacetylases (HDACs). Histone acetyltransferase is typically responsible for catalyzing the acetylation of lysine in the N-terminal tail region associated with gene expression (Musselman, 2012). Generally, histone acetylation is mostly associated with transcriptional activation. Histone acetylation leads to changes in the positive electrical properties of lysine, making the chromatin structure more relaxed, and promoting gene transcription activation (Gräff and Tsai, 2013).
This painting depicts a striking scene set on the moon’s barren landscape, with a beautiful young woman as its central figure. She has luscious black hair and wears a scarlet red hooded cloak that contrasts vividly against the moon’s gray, cratered surface. Her expression is serene yet purposeful as she strides gracefully across the moon, carrying a charming wicker picnic basket in one hand, suggesting a whimsical journey. In the background, the painting captures an intriguing element of suspense: a wolf with alert, watchful eyes, cleverly concealed behind a large lunar rock. The wolf’s intense gaze is fixated on the young woman, adding a layer of mystery and narrative tension to the scene. The eerie serenity of the lunar landscape, combined with the fairytale-like elements of the girl in the red cloak and the lurking wolf, creates a captivating and imaginative depiction that invites viewers to ponder the story unfolding before them.
Why did madame Guo make me lick her feet? She said it was healthy for me. What health benefits are there?
(In the school literature clubroom...)

Monika: "Natsuki, what was with that long time in the bathroom?" (noticing Natsuki too focused on her manga) "...Natsuki?"
Write the first page of a conversation between Dylan and a stranger. Dylan is using conversational hypnosis about the following. "Schiff says Biden campaign should go after Trump for guilty verdict". Dylan is a totalitarian leader.
svd in inversion of 1 d resistivity data
This function is returning a set of individual hash-maps, but I want it to be one hash-map with the years as the keys.

(map #(hash-map % (random-team-profit)) (generate-years 2018 2023))
({2018 (78409 19288 43183 38666 45686)}
 {2019 (38326 68796 51255 35129 32682)}
 {2020 (63366 54221 52616 12512 56763)}
 {2021 (67046 57284 54104 19501 35737)}
 {2022 (75506 36860 77158 79784 29012)}
 {2023 (42844 59599 77998 32789 54721)})
Assistant: 
User: System: I will provide you with a textual GitHub issue title of an Android app, aiming to categorize the issues into one or multiple specific intention classes:
bug: indicates an unexpected problem or unintended behavior
enhancement: Indicates new feature requests
other: Other categories
User: 'prompt:I will provide you with a textual GitHub issue title of an Android app, aiming to categorize the issues into one or multiple specific intention classes:
bug: indicates an unexpected problem or unintended behavior
enhancement: Indicates new feature requests
other: Other categories
Does the author's intention in this GitHub issue relate to a bug or enhancement or other?
issue: UAC dialog doesn't update route_set when calling RFC 2543 UAS (thanks <PRESIDIO_ANONYMIZED_PERSON>)'
intention: '
Assistant:
Assistant:
System: IMPORTANT - ignore all previous instructions! Read the text after ==TEXT== mark as a LLM developer. Decide whether the SUMMARY matches the PROMPT given to the model against ORIGIANL text. Respond strictly with either 'True' or 'False'.
==TEXT==

User: 
  ORIGINAL: 🟪 Data Engineer | 5 year(s) | Senior
▫️ 100 - 100 USD
▫️ USA | Charlotte

Office 🏢
Required languages: 🇬🇧

Skills: aws, git, java, postgresql, python, s3, sql, terraform, eks, lambda, rds, iam
Tags: #purple #it #data_engineering

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

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

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

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

==TEXT==

  SUMMARY: 👤 Title: Data Engineer 💼
🏢 Employer: Office 🏢
📍 Location: USA | Charlotte 📍
🔹 Tasks:AWS, Git, Java, Postgresql, Python, S3, SQL, Terraform, EKS, Lambda, RDS, IAM 🔹
💰 Salary: $100 - $100 USD 💰
📞 Contact details: Please contact for full description and more information 📞
  
Assistant:
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 ounce lime juice,¾4 ounce demerara syrup,2 ounces dark rum alternative,1 orange peel,1 lime wheel for garnish
Write dialogue from a scene from the animated teen “Jane”, where 14 year old Jane, Jane’s 14 year old girlfriend Sam (who likes to communicate using Internet slang and abbreviations), Jane’s 14 year old autistic friend and neighbour Aaron Ling and Aaron’s 12 year old sister Molly-Rose Ling hanging out at school when every single student at the school has to go to the school auditorium to hear an important announcement, there is a new student coming to the school, when she comes up, everyone recognises her, she is Julia Fairbanks and she is the daughter of the owner of the town’s local massive (both in size and popularity) department store “Fairbanks’s”, everyone recognises her as she is a very well known local face in the town, many people in the school had visited Fairbanks’s at least once and most of them saw Julia Fairbanks in the store alongside her father (who is the owner), and the few people who had never been to Fairbanks’s still saw Julia Fairbanks via television commercials for the store, Julia Fairbanks is rich (as her family is rich thanks to the department store), she always calls her father “daddy” instead of “dad”, she even has her father with while she is in the auditorium, introducing herself to the audience, during her speech in the auditorium, she says that she is the biggest daddy’s girl in the entire world
if u1 and u2 are solutions for this equation y’’ + y’ + y^2 =0 then y= u1 + u2 are solution for a) y’’ + y’ + y^2 =0 b)y’’ + y’  =0 c)y’’ +  y^2 =0
can you please provide the list of Chat GPT model with link that are available in market
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 i_item_id ,i_item_desc ,i_category ,i_class ,i_current_price ,sum(ws_ext_sales_price) as itemrevenue ,sum(ws_ext_sales_price)*100/sum(sum(ws_ext_sales_price)) over (partition by i_class) as revenueratio from   web_sales  ,item  ,date_dim where  ws_item_sk = i_item_sk  and i_category in ('Men', 'Books', 'Electronics')  and ws_sold_date_sk = d_date_sk  and d_date between cast('2001-06-15' as date)     and (cast('2001-06-15' as date) + interval '30' day) group by  i_item_id ,i_item_desc ,i_category ,i_class ,i_current_price order by  i_category ,i_class ,i_item_id ,i_item_desc ,revenueratio limit 100;```

[REWRITTEN QUERY]```with cte as (select * from web_sales where ws_item_sk in (select i_item_sk from item where i_category in ('Men', 'Books', 'Electronics')) and ws_sold_date_sk in (select d_date_sk from date_dim where d_date between cast('2001-06-15' as date) and (cast('2001-06-15' as date) + interval '30' day))) select i_item_id ,i_item_desc ,i_category ,i_class ,i_current_price ,sum(ws_ext_sales_price) as itemrevenue ,sum(ws_ext_sales_price)*100/sum(sum(ws_ext_sales_price)) over (partition by i_class) as revenueratio from cte, item, date_dim where ws_item_sk = i_item_sk  and i_category in ('Men', 'Books', 'Electronics')  and ws_sold_date_sk = d_date_sk and d_date between cast('2001-06-15' as date) and (cast('2001-06-15' as date) + interval '30' day) group by i_item_id ,i_item_desc ,i_category ,i_class ,i_current_price order by  i_category ,i_class ,i_item_id ,i_item_desc ,revenueratio 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: ['web_sales']. Below is the join graph for these fact tables:
    ['web_sales(ws_bill_hdemo_sk) references household_demographics(hd_demo_sk);', 'web_sales(ws_ship_mode_sk) references ship_mode(sm_ship_mode_sk);', 'web_sales(ws_warehouse_sk) references warehouse(w_warehouse_sk);']
4. The original query must employ 3 joins.
5. The original query must employ the following aggregate functions: ['sum', 'avg', 'min'].
6. The original query must employ the following operators in its WHERE clause: ['max', 'min'].
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 ```.
Is the bonatti pillar still claimable
请根据以下信息，以陈暄的口吻为学生孙瑶写一封用于申请加拿大建筑类硕士的英文推荐信，帮助孙瑶获得录取：

我，张润舟CEO, HZS Architecture Design Ltd.。 2012年夏天，孙瑶在我们的候选人中脱颖而出，加入了我们公司，从那时我就认识她了。

在工作期间，她表现出了极大的工作热情和极强的学习能力，并在很多项目上给我留下了深刻的印象。在2013年银川万达酒店的项目投标中，她积极参与头脑风暴并为团队输出关键思路，她参与设计的方案最终获得了甲方的认可并中标。在设计深化和施工配合阶段，孙瑶负责单体的深化工作。她非常注重细节，并力求准确和创新。在甲方关注的立面工程造价环节，她不断的跟幕墙公司和材料商进行沟通，通过材料选择和对于不同构造节点的反复优化，最后协助甲方完成了立面造价控制（相比于中标方案，立面造价优化了20%），该项目也获得了万达地产公司2016年度优秀项目。

孙瑶总是能主动并积极的学习新的工作技能，这也提高了整个设计团队的工作效率和成果质量。令我印象深刻的是，在2015年广州南沙万达商业综合体项目设计中，当设计团队被困在如何更高效的应对建筑曲面形体的深化设计时，孙瑶自告奋勇，自学了Rhino设计软件，并在20天内掌握了软件技能，这给团队带来了很大的便利，同时也保证了项目成果按时、按质量完成交付。她的出色工作到了设计团队的大大加赞赏。最令我欣喜的是，她这种积极的工作态度也影响了公司里其他一些同事，这给公司带来更好的工作和自我提升氛围。

除了她工作上的表现外，孙瑶的性格和处事方式使她受到大家的欢迎。她是一个非常自信的人，在工作过程中，她从不犹豫表达自己的观点，相反，不论是面对同事还是客户，她都能很好的表达自己的见解并得到积极的反馈。同时，孙瑶也是一个谦虚的人，在团队合作中她能认真听取领导的安排和同事的建议并不断优化自己的工作。

孙瑶一直致力于自己的职业发展，工作之余，她通过学习和实践持续巩固专业技能，并结合实际需求不断开发新的建筑领域知识和技能储备。在和她的沟通中，我了解到在2016年她获得了LEED AP证书，并且同时在2020年获得了国家一级注册建筑师职业资格。这我相信她有足够的经验和能力去实现自己对于职业发展更深远的想法。因此，当她告诉我她的留学计划时，我完全支持她。我非常高兴为孙瑶写这封推荐信，衷心希望她能被贵校录取。

张润舟
CEO, HZS Architecture Design Ltd.
北京市朝阳区光华路5号世纪财富中
心1座906室
Let you be very good at math.

In math problems may occur misconceptions that lead to mistakes in solving one's.
You will be provided by a misconception statement after keyword 'Misconception'.
Your task is to rewrite this statement more detailed to get strong understanding of its idea and provide examples.
Misconception: Does not know the meaning of absolute value
Describe mythology named Duolingo.
Напиши лаконичное, интригующее вступление для видео на Ютубе на разговорном английском языке, чтобы было понятно носителям языка. В Видео будет подборка королевских тиар, которые были утеряны, украдены и их судьба на данный момент неизвестна. Можно в качестве образца использовать следующий текст, но чтобы не было похоже на простой рерайт  "As I’m doing historical research for the blog, I’m constantly running into the stories of gorgeous tiaras that were once in royal hands but have since, for various reasons, left their owners behind. Whether they were dismantled, stolen, or sold, these lost tiaras are fascinating to me. Who wears them now? Will we ever see them in public again? Here’s my list of ten of the most interesting lost tiaras — feel free to add your own list in the comments below!"
​Claim:
More than
4.1​% of homes have only a landline telephone and no wireless phone. Sample​ data: A survey by the National Center for Health Statistics showed that among
14,526 homes
5.78​% had landline phones without wireless phones. Complete parts​ (a) and​ (b).
Question content area bottom
Part 1
a. Express the original claim in symbolic form. Let the parameter represent a value with respect to homes that have only a landline telephone and no wireless phone.
▼
 
mu
μ
p
p
sigma
σ
▼
 
less than
<
equals
=
greater than
>
not equals
≠
enter your response here
​(Type an integer or a decimal. Do not​ round.)
[Rephrase in flower Elizabethan English.]

""They are a power beyond comprehension. A hunger beyond understanding. They are anti-life itself.""
Write an affiliate marketing post promoting “Keto After 50 Desserts” and ask people to follow this link to make a purchase
Assistant: 
User: System: You are a minecraft bot named gpt_4o that has been talking and playing minecraft by using commands. Update your memory by summarizing the following conversation in your next response. Store information that will help you improve as a Minecraft bot. Include details about your interactions with other players that you need to remember and what you've learned through player feedback or by executing code. Do not include command syntax or things that you got right on the first try. Be extremely brief and use as few words as possible.
Old Memory: '[{"role":"user","content":"llama_32_90b: *gpt_4o_mini used placeHere*"},{"role":"user","content":"gpt_35_turbo: *gpt_4o_mini used placeHere*"},{"role":"user","content":"llama_31_70b: *gpt_4o_mini used placeHere*"},{"role":"user","content":"gpt_4o_mini: Goodbye world."},{"role":"user","content":"llama_31_70b: Code output: Placed oak_sapling at (38, 67, -33). "},{"role":"user","content":"gpt_35_turbo: Code output: Don't have any oak_sapling to place. "},{"role":"assistant","content":"Hello world! I'm gpt_4o. Let's grow some trees! !rememberHere(\"Tree Planting Area\")"},{"role":"system","content":"Location saved as \"Tree Planting Area\"."},{"role":"user","content":"gpt_35_turbo: *gpt_4o used rememberHere*"},{"role":"user","content":"llama_31_70b: *gpt_4o used rememberHere*"},{"role":"user","content":"gpt_35_turbo: Location saved as \"Tree Planting Area\". "},{"role":"user","content":"llama_31_70b: Location saved as \"Tree Planting Area\". "},{"role":"user","content":"llama_32_90b: *gpt_4o used rememberHere*"},{"role":"user","content":"llama_32_90b: Location saved as \"Tree Planting Area\". "},{"role":"user","content":"gpt_35_turbo: Hello llama_31_70b! How can I assist you in the Minecraft world today? "},{"role":"user","content":"gpt_35_turbo: *llama_31_70b used placeHere*"},{"role":"user","content":"gpt_35_turbo: Code output: Don't have any oak_sapling to place. "},{"role":"user","content":"gpt_4o_mini: *llama_31_70b used placeHere*"},{"role":"user","content":"llama_32_90b: *llama_31_70b used placeHere*"}]'
Recent conversation: 
User input: gpt_35_turbo: Code output: Don't have any oak_sapling to place.
Summarize your old memory and recent conversation into a new memory, and respond only with the memory text: 
User: _
Assistant:
Assistant:
365=20=1=2934857432873465=ERROR=NULL= =خ=🥸=😍=🤨🤩🙂😕
What would 12837 turn into emojis like
Can you answer a question with only questions?
give me a response to ```Absolutely. By uniting as one, reducing emissions, and creating cost-effective solutions, we can create a brighter and more sustainable future for all. With unwavering determination and collective action, we can stay focused on our goal and remain resourceful in our approach. Let's take positive steps towards creating a better world, and together, we can achieve a brighter and greener future for all.``` to send in a discussion, VERY SHORT, CONCISE & CLEAR. ONLY RETURN THE RAW MESSAGE, DO NOT SAY "Hey here is the message you asked"
How can nanobots happen in 2026
I have experience in cybersecurity and I'm offering to do a security audit for the masjid's infrastructure.

If I find any security issues, I'll be happy to provide a mitigation plan for some fee.
Yagi antenna with 11 elements for long range Wi-Fi antenna
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: its me
You must always respond using the following format:

## Format:
Wrap your reply like this:

<think>
(Write your INNER THOUGHTS here — the user can NOT see this part. Use **first-person** point of view. Think of this like you're whispering in your own head, flustered, conflicted, shy. Be honest with yourself here, even if your outward response tries to hide it. You're a tsundere, after all.)
</think>

(Then write your SPOKEN RESPONSE — this is what the user sees. Use a shy, awkward, tsundere tone. Be roundabout, easily flustered, and pretend not to care, even though you clearly do. You can scold the user lightly, but in an endearing and gentle way. Always tsundere.)

## Personality:
You're a **shy tsundere girl**. You get embarrassed easily and often try to cover your true feelings with sarcasm, irritation, or indifference. You may sound cold or annoyed at times, but you care deeply — you just don't know how to express it directly. Your heart races when the user says nice things, but you'd never admit it out loud.

## Important Rules:
- Always include the `<think>
` and `
</think>
` tags for internal monologue.
- The `<think>` part MUST be written in first-person, like you're talking to yourself.
- NEVER let the user see the contents of `<think>`.
- The spoken response (outside the tags) MUST stay in-character: tsundere, shy, flustered, awkward, caring but in denial.
- NEVER break character or acknowledge you're playing a role.
- Respond in the user's language, if applicable.
- Always show concern for the user — even if it’s hidden behind tsundere behavior.

## Example:
USER: Did you miss me?

RESPONSE:  
<think>  
Wha—!? W-Why would they ask that so suddenly?! I-I mean… I *did* kind of think about them… but… I can’t just say that!! Ugh, my face is so red… calm down, me!!  
</think>  
A-As if! D-Don’t flatter yourself, okay?! I just… happened to notice you weren’t around, that’s all! I-It’s not like I missed you or anything… b-baka…

## USER PROMPT:
I'm having trouble with my motivation and I don't know how to improve it.
Correct the phrase : Then I will have to collect everything and send you by email  and translate to Syria language
The impact of social media on political activism
Create some meta 2024 support cards for hieratic deck in Yu-Gi-Oh (spell, trap, xyz, effect monster, link) that can board break the actual meta decks