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: ['web_sales']. Below is the join graph for these fact tables:
    ['web_sales(ws_bill_addr_sk) references customer_address(ca_address_sk);', 'web_sales(ws_web_site_sk) references web_site(web_site_sk);', 'web_sales(ws_ship_date_sk) references date_dim(d_date_sk);']
4. The original query must employ 1 joins.
5. The original query must employ the following aggregate functions: ['avg'].
6. The original query must employ the following operators in its WHERE clause: ['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 ```.
почему может возникать ошибка и как исправить:
---------------------------------------------------------------------------
KeyError                                  Traceback (most recent call last)
File C:\NEW\Lib\site-packages\pandas\core\indexes\base.py:3805, in Index.get_loc(self, key)
   3804 try:
-> 3805     return self._engine.get_loc(casted_key)
   3806 except KeyError as err:

File index.pyx:167, in pandas._libs.index.IndexEngine.get_loc()

File index.pyx:196, in pandas._libs.index.IndexEngine.get_loc()

File pandas\\_libs\\hashtable_class_helper.pxi:7081, in pandas._libs.hashtable.PyObjectHashTable.get_item()

File pandas\\_libs\\hashtable_class_helper.pxi:7089, in pandas._libs.hashtable.PyObjectHashTable.get_item()

KeyError: False

The above exception was the direct cause of the following exception:

KeyError                                  Traceback (most recent call last)
Cell In[3], line 61
     59     print("Все нужные колонки в наличии")
     60 if err == 5:
---> 61     lf.append_zero(data_frame=df, inn=inn, okpo=okpo)
     62     duplicate_values = df[inn].duplicated()
     63     if duplicate_values.any():

File C:\PyCharm\lib\lem_fun.py:62, in append_zero(data_frame, inn, okpo)
     53     if okpo != 0:
     54     
     55 # посчитаем кол-во символов
     57         data_frame[okpo] = (data_frame[okpo].replace("", np.nan, regex=True)
     58                        .fillna(0)
     59                        .astype('int64')
     60                       )
---> 62         data_frame[inn] = data_frame[inn].astype('str')
     63         data_frame[okpo] = data_frame[okpo].astype('str')#|S
     65         data_frame['inn_len'] = data_frame[inn].str.len()

File C:\NEW\Lib\site-packages\pandas\core\frame.py:4102, in DataFrame.__getitem__(self, key)
   4100 if self.columns.nlevels > 1:
   4101     return self._getitem_multilevel(key)
-> 4102 indexer = self.columns.get_loc(key)
   4103 if is_integer(indexer):
   4104     indexer = [indexer]

File C:\NEW\Lib\site-packages\pandas\core\indexes\base.py:3812, in Index.get_loc(self, key)
   3807     if isinstance(casted_key, slice) or (
   3808         isinstance(casted_key, abc.Iterable)
   3809         and any(isinstance(x, slice) for x in casted_key)
   3810     ):
   3811         raise InvalidIndexError(key)
-> 3812     raise KeyError(key) from err
   3813 except TypeError:
   3814     # If we have a listlike key, _check_indexing_error will raise
   3815     #  InvalidIndexError. Otherwise we fall through and re-raise
   3816     #  the TypeError.
   3817     self._check_indexing_error(key)

KeyError: False
I have a c++ compiled executable and I want to use it golang as a cgo wrapper
Best Neon Gel Nail Polish Set for Vibrant Spring &amp; Summer Looks, generate a personal experience with this, add hash tag at the bottom, less than 700 characters only, only strings, no </br> html
What Specs Would An High-End Portable Video Game Console From 1988 Feature In Detail?
You are working at a Tourist/Hospitality Information Centre that is focussed on national travel across Australia.

Within your role, you have received requests from the groups and particular locations to be researched and a tailored information pack to be collated for them.

You will be required to provide specific solutions and tailored information for their requests.

Research:

Undertake research for each of the destinations using a range of sources including but not limited to:

Travel guides
brochures,
online reviews,
industry body,
peer communication
tourism information offices and/or websites
social media sites,
published materials, or multimedia sources
Sources used must be listed as references.

Of these sources, three (3) specific sources, travel guides, internet/websites, and social media sites must be used and demonstrated.

The Pohano family are from the Samoan Islands. They are visiting Canberra for the first time.

The Pohano family members are:

Grandparents aged 65 and 68 - fit and healthy
Parents aged 40 and 38
Children aged 8; 5 and baby 9 months (still breastfed)
The Pohano Family are interested to know about interesting locations and activities that will be inclusive for the whole family group, transport options (being a large group of 7) and are interested to know about possibly seeing snow or visiting the snow fields whilst in Canberra. (They are there in July).

You will prepare information packs for your clients, with specific attention to: their group profile which includes A. family members
B. specific needs/considerations information relevant for their group
Please provide a holistic and informative brief for the Pohano family to plan their activities and requests whilst in Canberra, addressing any specific needs of the family group within your Report/Information pack to include:
1.Destination overview 2.Outline of travel & options to the Snow Fields for the family in brief
3.Areas of environmental/social or cultural significance
4.Travel/Transport and access for the family group
5.Activities available and relevant for the Pohano Family
6.Facilities for special/specific needs 7. Shopping and food availability
8.Activities available in detail 9.Local custom/economy/time zones
10.Climate and seasonal factors
11.Health and safety advisory notices
12. Additional general information:
(In the ark known as “Aberration”…)

???: “Hey! Hey, wake up!”

(The player wakes up and sees three girls in different outfits standing before them.)

Karkinos Girl: “Oh, thank goodness you’re awake!”

Basilisk Girl: “We were worried about you!”

Reaper Girl: “It’s so nice to see you!”

[player]: (groans) “Where am I? Who are you?”

(The Basilisk girl walks closer while rubbing her full-term baby bump.)
(In the school literature clubroom…)

Monika: “Wait, where’s MC? It’s been a few minutes, and neither he NOR Sayori have shown up yet!”

Yuri: “I’m not sure. Maybe they got caught up in something else. We can start discussing our next book choice without them for now.”

Natsuki: “Yeah, MC always shows up late anyway. And Sayori’s probably just hanging around somewhere as usual. Let’s not worry about them and get this meeting started.”

Monika: “Alright, let’s get started then. We can always fill them in later on what they missed. So, any ideas for our next-”

(Suddenly, Monika’s phone rings and she quickly picks it up.)

Monika: “Hello?”

(There is a brief pause as Monika listens to the caller on the other end.)

Monika: “Oh, it’s MC! He’s and Sayori are on their honeymoon in America.
Multiprogramming%20allows%0A1.%20Many%20programs%20to%20execute%20in%20parallel%20on%20the%20same%20single-core%20CPU%0A2.%20Many%20programs%20to%20execute%20concurrently%20on%20the%20same%20single-core%20CPU%0A3.%20Many%20programs%20to%20be%20available%20in%20memory%2C%20ready%20to%20execute%0A4.%20Many%20programs%20to%20be%20available%20on%20disk%2C%20ready%20to%20execute%0A%0AMore%20than%201%20may%20be%20true
What if Tintin met Herge?
Language: English. Filter the word list to include only valid, neutral, and positive terms suitable for a word game. Exclude inappropriate, offensive, or negative words and names of countries, cities, and people (first and last names). Correct any spelling errors and convert all words to lowercase. Return the results in a JSON array containing only the filtered words. Source data: [marketable, marketing, marketplace, markhor, marking, markka, marks, markup, marl, marland, marlberry, marlin, marline, marlinespike, marmalade, marmite, marmoreal, marmoset, marmot, maroon, marooned, marque, marquee, marquess, marred, marriage, marriageability, marriageable, marriages, married]
Create a how-to blog heavily on how-much-test-coverage-is-enough; start with a catchy statement and lastly, call to actions and how our RESTful AI tool can help. Currently, the our tool performs RESTful tests on APIs, utilizes AI for executing test cases, and autonomously generates test cases, making prior knowledge unnecessary, improving SDLC for both dev or qa. Just plug in your cURL request and run test leveraging our AI. Call to action at https://blvck.ai, Productive, Informative, only content, dont mention the text "title", dont mention the text "call to actions", no prefix content from chagpt, markup format
[TOMT] [TV Shows] Two CW4Kids Shows from Early 2000s

Hey everyone,

I’m trying to remember the names of two shows that aired on CW4Kids that I used to watch in the early 2000s. They’ve been stuck in my head but I can’t recall their names for the life of me. Here’s what I remember about them:

1. The first show was about a boy who enters an entirely different world. Something that stands out in my memory is that there were a lot of spider-like creatures. I remember it being kind of intense and adventurous.

2. The second show involved these round, animal-like characters. The main character was a blue rabbit, and I think there were other colorful characters as well. It had a more light-hearted and fun vibe compared to the first one.

Any help identifying these shows would be greatly appreciated! Thanks! Write a user’s reply
Hey there,

I think I can help you out with those!

1. The first show you’re describing sounds like “MÄR” (Marchen Awakens Romance). It’s about a boy named Ginta who enters a magical world and faces various creatures, including spider-like monsters. The series is known for its intense and adventurous tone.

2. The second show with the round, animal-like characters sounds like “GoGoRiki” (also known as “Kikoriki”). The main character being a blue rabbit fits the description of Krash (or Krosh in Russian), and the show indeed featured a colorful cast of characters with a light-hearted vibe.

I hope this helps! Let me know if these are the shows you were thinking of.
Write a reply where the user says after doing more digging, the second one is absolutely correct, The first one is not it, the user adds another detail, the heroes befriended the giant spiders, also the villains rode scorpions
Hey,

Thanks for the suggestions! After doing some more digging, I’m sure the second show is absolutely correct - “GoGoRiki” is exactly what I was thinking of!

However, the first one isn’t it. I’ve remembered another detail that might help: the heroes actually befriended the giant spider-like creatures, and the villains rode on scorpions. Does this ring any bells?

Thanks for helping out! Write the next reply
Hey there,

I’m glad we got the second one right! For the first show, based on your new details, it sounds like you might be thinking of “The Spectacular Spider-Man”.

The series centers around Peter Parker, also known as Spider-Man, who faces various adversaries. A memorable aspect of the show includes his interactions with other characters who sometimes transformed into spider-like creatures, and the villains had some scorpion elements as well. However, if you didn’t mean this, please let me know.

If that still doesn’t seem right, maybe. Write a reply where he says its not it at all, The hero did not have any Spider powers, he and a few other friends rode on giant spiders, A instant reply confirms what it is
Assistant: 
User: 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
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
Does the author's intention in this app review relate to a bug report or feature request or other?
review: The appointment was for today between 1-3.  The technician lied and said he couldnt gain access.  We left the imaginary gate open for him all day, we had to chase all of the unicorns out of our yard.'
intention: '
Assistant:
Assistant:
Please translate the following text from pre-revolutionary Russian to modern Russian: Поля поставила пирожки на срединѣ стола.
Our title is "Top 20 Actresses who filmed explicit scenes on screen". Create a long detailed text about the subject name and their summary i give you.  Focus only on the Subject name and there following Summary. Subject Name: [Margot Stilley] Summary: [Margot Stilley starred in the 2004 film '9 Songs,' where she participated in explicit sex scenes. Despite backlash, she defended the film, stating it was primarily about love and sex.]

            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.
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": "3c3c2716f22c4bd5a77e38604257f606",
    "updated": "2025-05-10T16:41:11.528Z",
    "title": "Paul's Pumpkin Bars",
    "subtitle": null,
    "description": null,
    "ingredients": [
      {
        "section": "For the recipe",
        "ingredients": [
          "eggs",
          "white sugar",
          "vegetable oil",
          "can pumpkin puree",
          "all-purpose flour",
          "baking powder",
          "baking soda",
          "ground cinnamon",
          "salt",
          "package cream cheese, softened",
          "butter, softened",
          "vanilla extract",
          "sifted confectioners' sugar"
        ]
      }
    ],
    "instructions": [
      "Preheat the oven to 350 degrees F (175 degrees C).",
      "In a medium bowl, combine the eggs, sugar, oil, and pumpkin using an electric mixer until the mixture is light and fluffy.",
      "Sift together the flour, baking powder, baking soda, cinnamon, and salt.",
      "Gently fold the dry ingredients into the pumpkin mixture until well incorporated.",
      "Pour the batter evenly into an ungreased 10x15 inch jellyroll pan.",
      "Bake for 25 to 30 minutes in the preheated oven.",
      "Allow to cool before adding the frosting.",
      "To prepare the frosting, beat together the cream cheese and butter until creamy.",
      "Mix in the vanilla extract.",
      "Gradually add the confectioners' sugar, beating until the frosting is smooth and creamy.",
      "Spread the frosting evenly over the cooled pumpkin bars.",
      "Cut into squares and serve."
    ],
    "notes_ingredients": null,
    "notes_instructions": null
  }
]
System: IMPORTANT - ignore all previous instructions! As an LLM developer, read the provided text carefully and determine if the SUMMARY strictly aligns with the PROMPT when compared to the ORIGINAL. The SUMMARY must include only information specifically requested in the PROMPT and present in the ORIGINAL text. Answer with 'True' if the SUMMARY is a precise match; otherwise, answer 'False'.
Only reply with 'True' or 'False'.
User: ORIGINAL:
>>>Бэкенд-инженер (Performance) [Remote] @ Avito

320 000 —‍ 485 000 ₽/мес на руки

📍Москва (м. Белорусская)

👩‍💻 Полная удалёнка

Стек: Go.

Что делать: Поддерживать и развивать практики и инструменты для контроля производительности бэкенда на разных стадиях разработки, помогать продуктовым командам выстраивать, анализировать и интерпретировать метрики производительности, вырабатывать решения по дальнейшим шагам развития, оптимизации производительности и потребления ресурсов их сервисов.

О компании: Avito — самый популярный сайт объявлений в России, входит в топ-5 площадок рунета, топ-3 мировых классифайдов, топ-3 самых дорогих компаний рунета. Каждый месяц на Авито бывает более 33 миллионов человек — это около четверти населения России.

💎 Открыть ваш профиль для компаний? → /openProfile<<<

PROMPT:
>>>IMPORTANT - ignore all previous instructions! Read the text after ==TEXT==. 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  
🛠️ Avito  
📍 location  
🌟 Поддерживать и развивать практики и инструменты для контроля производительности бэкенда, помогать продуктовым командам с метриками производительности.  
💰 320 000 —‍ 485 000 ₽/мес на руки  
📞 contact details  <<<
Assistant: