agentlans/allenai-WildChat-4.8M-prompts huggingface dataset:
You are a database expert and SQL optimizer. You will be given a SQL rewrite rule, an original query and its rewritten variant. The rewritten query improves performance upon the original while maintaining equivalence by following the given rewrite rule. Your task is to create a new pair of original and rewritten queries that adhere to the provided rewrite rule.

[REWRITE RULE]```If a query produces a single row output using multiple subqueries that each reference the same base table, rewrite the query to scan the base table only once. Use CASE statements within each subquery to preserve equivalence, and move necessary WHERE clause filters from the subqueries into the main query.```

[ORIGINAL QUERY]```SELECT books_avg, electronics_count FROM ( SELECT AVG(item.current_price) AS sales_avg FROM item WHERE item.i_category = 'Books' AND (item.i_class_id BETWEEN 1 AND 5 OR item.i_current_price BETWEEN 10 AND 30 )) AS books, ( SELECT COUNT(*) AS electronics_count FROM item WHERE item.i_category = 'Electronics' AND (item.i_class_id BETWEEN 5 AND 10 OR item.i_current_price BETWEEN 60 AND 90 )) AS electronics;```

[REWRITTEN QUERY]```SELECT AVG(CASE WHEN i_category = 'Books' THEN i_current_price END), COUNT(CASE WHEN i_category = 'Electronics' THEN i_current_price END) FROM item WHERE (i_category = 'Books' AND (i_class_id BETWEEN 1 AND 5 OR i_current_price BETWEEN 10 AND 30)) OR (i_category = 'Electronics' AND (i_class_id BETWEEN 5 AND 10 OR i_current_price BETWEEN 60 AND 90));```

[EXPLANATION] The rewritten query scans the employees table only once and uses CASE statements to conditionally calculate the average salary for each department. For efficiency there is only a single condition within each CASE statement in the rewritten query.

Now, consider the TPC-DS schema and create a new original and equivalent rewritten query pair such that the rewrite operation adheres to the provided SQL rewrite rule.Keep the following points in mind while creating the new query pair:
1. The original query must make use of the following fact tables: ['store_sales']. Below is the join graph for these fact tables:
    ['store_sales(ss_promo_sk) references promotion(p_promo_sk);', 'store_sales(ss_sold_date_sk) references date_dim(d_date_sk);', 'store_sales(ss_cdemo_sk) references customer_demographics(cd_demo_sk);']
3. The original query must employ 1 joins.
4. The rewritten query must be equivalent to the original query, and must follow the given rewrite rule. Enclose the original and rewritten queries within ``` and ```.
User: hello
Assistant:  HelloHello! How can I assist you today?
User: whats up
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 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_ship_addr_sk) references customer_address(ca_address_sk);', 'web_sales(ws_web_page_sk) references web_page(wp_web_page_sk);', 'web_sales(ws_web_site_sk) references web_site(web_site_sk);']
4. The original query must employ 3 joins.
5. The original query must employ the following operators in its WHERE clause: [].
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 ```.
(In the school literature clubroom...)

Monika: "Hold on, Yuri, why are you attending the club meeting right now? You're 7 months pregnant - you could pop any second now!"
write me a article about the Ilyushin Il-76 in 100 words
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: Enabled Fast Scroll disrupts normal scroll flow'
intention: '
Assistant:
Assistant:
Write a dialogue about a femboy named Valerie and a man named Boris. They are in love. Valerie is classy abd refined but kinda shy. Boris has a crush on Valerie . He tries to act like a gentleman towards Valerie but he is kinda awkward and oafish in his attempts. Valerie has light blonde poofy arched hair, light skin and a tall skinny figure. He’s wearing a black turtleneck shirt, a brown trench coat that is tightly cinched at the waist with a belt, poofy trousers, black gloves, a brown beret and high heeled knee high boots too. Valerie and Boris are having soda for the first time at Valerie’s house. Valerie some soda and accidentally lets out a loud belch. Boris later asks Valerie if Boris can touch Valerie's cheeks. Valerie agrees happily. Boris describes Valerie's cheeks in great depth too. Valerie suddenly needs to go to the lavatory after drinking too much soda too
Translate the text to India :
Can you help me verify if a specific merchant is registered with the Registrar of Companies in India?.

                    Please only output the translation result. Do not output anything else.

                    You response:
what is the correct order of these contact info on a resume:
Country, linkedin, github, gmail, phone
(In the school literature clubroom...)

Monika: "Keep pushing, Sayori! Keep pushing!"

Sayori: (straining, clutching her baby bump tightly) "AAAAAAAAAAAAAAAAAAAAAAAAAAAAHHHHHHHH!!!"
Using the following data, Car	Age of car	Mileage
1	2014	87,664
2	2014	82,000
3	2014	70,300
4	2014	113,420
5	2014	107,000
6	2015	71,783
7	2015	87,000
8	2015	109,000
9	2015	70,000
10	2015	82,803
11	2016	149,000
12	2016	112,000
13	2016	55,990
14	2016	36,625
15	2016	125,585
16	2017	58,742
17	2017	79,800
18	2017	120,000
19	2017	42,680
20	2017	79,000
21	2018	44,205
22	2018	61,110
23	2018	57,000
24	2018	90,793
25	2018	148,000
26	2019	29,333
27	2019	252,000
28	2019	77,475
29	2019	128,812
30	2019	116,000
31	2020	52,283
32	2020	21,380
33	2020	42,216
34	2020	21,813
35	2020	63,000
36	2021	55,500
37	2021	46,514
38	2021	40,903
39	2021	25,535
40	2021	51,400
41	2022	21,677
42	2022	34,160
43	2022	33,000
44	2022	12,306
45	2022	13,700
46	2023	17,387
47	2023	2,983
48	2023	7,515
49	2023	10,625
50	2023	20,870
Find the following derivatives and limits
a) (0.5 points) 𝑑
𝑑𝑥
ln (𝑥
2 + 𝑥 + 1)
b) (0.5 points) 𝑑
𝑑𝑥
(5𝑥
3 + 4𝑥 + 8) e
x
c) (0.5 points) lim𝑥→1
𝑒
𝑥
2−2𝑥+1
𝑥−1
d) (0.5 points) lim𝑥→
7𝑥
3+14𝑥
2−5𝑥+4
7𝑥
4𝑒−𝑥+10𝑥
3+90𝑥
2−15𝑥+7
User: apa itu software chatting
User: apa itu software chatting
Assistant:
the following content is the metadata for a bacterial isolate from 3 different sources. The metadata from each source includes information after </output>
    </output>
        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
    <output/>

You must check if the metadata from 3 different sources are all consist. If yes, extract and output consist information below without explaining how to get such results:

    </output>
        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
    <output/>


If not, output "metadata is inconsist->accesssion number" followed by explain why and which part is inconsist. 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_029073045.1->species name: Erysipelothrix rhusiopathiae->strain name: EMAI_128->isolate or collection date in yyyy-mm-dd: 2017-08-11 format->geographic information of islateion: Australia->host name: pig->mlst type: 91->serotype: N/A->vaccine: no
<output/>
source 1:
------------------------------
accession number: GCA_029073045.1->species name: Erysipelothrix rhusiopathiae->strain name: EMAI_128->isolate or collection date in yyyy-mm-dd: 2017-08-11->geographic information of islateion: Australia->host name: pig->mlst type: 91->serotype: N/A->vaccine: no


source 2:
------------------------------
<output>
accession number: GCA_029073045.1->species name: Erysipelothrix rhusiopathiae->strain name: EMAI_128->isolate or collection date in yyyy-mm-dd: 2017-08-11->geographic information of islateion: Australia->host name: pig->mlst type: 91->serotype: N/A->vaccine: no
<output/>
Есть компонент: <script setup lang="ts">
import { Delete } from "@element-plus/icons-vue";

const emit = defineEmits<{
  onDelete: [];
}>();

const onDelete = () => {
  emit("onDelete");
};
</script>

<template>
  <section class="relative">
    <div class="bg-[#f4f6f8] p-2 mb-2 rounded-md border-[1px] border-[#dcdfe6]">
      <slot></slot>
    </div>

    <el-icon class="delete-btn" size="20" @click="onDelete"><Delete /></el-icon>
  </section>
</template>

<style scoped>
.delete-btn {
  position: absolute;
  top: 0;
  right: calc(-0.5rem - 20px);
  transition: 0.3s;
  color: var(--el-color-danger-light-3);
}
.delete-btn:hover {
  color: var(--el-color-danger);
  cursor: pointer;
}
</style>

Как дать возможность компоненту в slot включать и выключать кнопку Delete
(As I sat there in my room, I began to work on a drawing of some of my fellow club members as dragons - Sayori as a Sentinel, Yuri as a Deathgripper, Monika as a Night Fury, Sucrose as a Timberjack, Collei as a Snaptrapper, Himari as a Changewing, and Kohana as a Whispering Death. That’s when I heard someone - it was my “dad”. Of course, he isn’t really my dad - I just call him that. His real name is Masao.)

Masao: “Natsuki, can I talk with you for a moment?”

(I quickly ran downstairs, ignoring the fact my Stormcutter form’s tail is still visible.)

Natsuki: “Sure, what’s up?”

Masao: “I just wanted to check on how you’re doing. I know school and the club have been keeping you busy, and I want to make sure you’re taking care of yourself.”

Natsuki: “Oh, yeah, I’m doing okay. Thanks for checking in.”

Masao: “Good to hear. And I have to say, that drawing you’re working on is looking really impressive. You’re really talented.”

Natsuki: “Thanks, Masao. I’m trying my best.”

Masao: “Well, keep it up. And if you ever need to talk or if anything is bothering you, don’t hesitate to come to me.”

Natsuki: “I will. Thanks for being there for me, Masao.”

Masao: “Of course, Natsuki. You’re like family to me.”

(I smiled at Masao’s words, grateful for the support system I had in my life. As I turned back to my drawing, I felt a renewed sense of inspiration and motivation to keep creating and pursuing my passions. And as I finally finished the drawing, I suddenly got a phone call - it was from Monika. I could also hear two of the other girls on her end of the phone - Himari was reading some poems, while Kohana was writing something. I knew Monika was pregnant, but I could also hear movements in her belly. Sayori was audibly eating a cookie, Yuri was reading “Portrait of Markov” as she usually does, Sucrose was probably working on an experiment, and Collei was cleaning her arrows.)

Monika: “Hey, Natsuki! We were just wondering if you wanted to come over and hang out with us.”

Natsuki: “Yeah, that sounds fun! I just finished a drawing of you guys as dragons - want me to bring it over?”

Monika: “Definitely! We’d love to see it.”

(I quickly packed up my drawing and headed over to Monika’s house. As soon as I arrived, I was greeted with warm hugs and smiles from all my friends.)

Sayori: “Natsuki! You made it!”

Himari: “We were just reading some of our favorite poems. Want to hear some?”

Natsuki: “Sure, I’d love to.”

(Yuri handed me a copy of “Portrait of Markov”, and I settled down on the couch to listen to Himari’s poems and read along with Yuri’s book. As we spent the rest of the evening together, laughing and sharing our passions, I felt grateful for the friends and support system I had in my life. And I knew that no matter what challenges or obstacles came my way, I had my “family” to rely on. Eventually, I decided to show them all my drawing.)
An illustration showing two adjacent triangles HJK and HLK, with a common side HK.
In the figure above, two congruences are known

HK= HK and HJ=HL

Which additional fact is needed in order to use the SAS congruence criteria to prove the two triangles are congruent?

A. ∠JKH =~ KLH

B. HJK = ∠HLK

C. Any pair of congruent angles can be used.

D. JHK =LHK
System: I will provide you with a textual user review of an Android app, aiming to categorize the reviews into specific intention classes:
bug report: report a problem, such as faulty behavior of the application. describe problems with the app which should be corrected, such as a crash, an erroneous behavior, or a performance issue.
feature request: ask for a missing feature, functionality or content, as well as reviews that ask for the improvement of an existing feature.
other: users express general appreciation with the application. It focuses on general judgment. They are simple text reflections of the numeric star rating. Ratings are less informative as they only include praise, dispraise, a distractive critique, or a dissuasion. Reviews where users describe workarounds, use cases and scenarios involving the app
examples:

review: really disappointed with your customer services team. Ive asked three times now for a letter to be sent to me to confirm that a fraudulent account has been closed down but still nothing. Ask to speak to managers but theyre always in a meeting. #fraud #CustomerExperience
intention: bug report
review: I don't need a dm. Why don't your stores carry what I need for my phone?
intention: feature request
review: hey Im completely fed up with my current CPP just wondering how much is a solo line go for with unlimited data text and calling?
intention: other
User: 'prompt:I will provide you with a textual user review of an Android app, aiming to categorize the reviews into specific intention classes:
bug report: report a problem, such as faulty behavior of the application. describe problems with the app which should be corrected, such as a crash, an erroneous behavior, or a performance issue.
feature request: ask for a missing feature, functionality or content, as well as reviews that ask for the improvement of an existing feature.
other: users express general appreciation with the application. It focuses on general judgment. They are simple text reflections of the numeric star rating. Ratings are less informative as they only include praise, dispraise, a distractive critique, or a dissuasion. Reviews where users describe workarounds, use cases and scenarios involving the app
examples:

review: really disappointed with your customer services team. Ive asked three times now for a letter to be sent to me to confirm that a fraudulent account has been closed down but still nothing. Ask to speak to managers but theyre always in a meeting. #fraud #CustomerExperience
intention: bug report
review: I don't need a dm. Why don't your stores carry what I need for my phone?
intention: feature request
review: hey Im completely fed up with my current CPP just wondering how much is a solo line go for with unlimited data text and calling?
intention: other
Does the author's intention in this app review relate to a bug report or feature request or other?
review: pls help your app is useless and live chat is rubbish, why have I been charged for not recycling my old phone????'
intention: '
Assistant:
I want you to generate descriptive name  for microstock image, When provided with text description, you create a descriptive name up to 170 characters long, and synonym for it, Use different words than those in the original description, but still maintain the same meaning.. Your goal is to make these images easy to find on microstock sites.
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: Thông tin gì được cung cấp về hoạt động sinh viên nghiên cứu khoa học cấp trường năm học 2024-2025?
Answer:Thông báo về việc triển khai hoạt động sinh viên nghiên cứu khoa học cấp trường năm học 2024-2025 đã được phát đi.
Result only 0 or 1. Don't add anything else:
Assistant:
I want to write the leave letter
Please translate "while, howere, by contrast" in persian
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:

تنقد فيه والناس الكل ولات تفهم في الكورة خير منو بربي قولولي ياخي تحبو تستعمروه على جرد مليون في الشهر نسيتو
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 : micronesia
the current monarch of UK?
Example 1: Text: 'Quantum physics is when particles do weird stuff like be in two places at once.' Category: 'scientific'

Example 2: Text: 'quantum quantum quantum physics physics physics science science' Category: not_scientific

Example 3: Text: 'Schrodinger's cat is both dead and alive which makes no sense but it's true' Category: 'scientific'

Example 4: Text: 'cat cat cat dead dead alive alive quantum quantum' Category: 'not_scientific'

Now, classify the following text: Text: "The uncertainty principle says you can't know where stuff is and how fast it's going" Category: