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: ['inventory']. Below is the join graph for these fact tables:
    ['inventory(inv_warehouse_sk) references warehouse(w_warehouse_sk);', 'inventory(inv_item_sk) references item(i_item_sk);', 'inventory(inv_date_sk) references date_dim(d_date_sk);']
3. The original query must employ 1 joins.
4. The original query must employ the following aggregate functions: ['max', 'avg'].
5. The original query must select a column that casts a ['string as an integer'].
6. 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 ```.
[SYSTEM you are a 14 year old girl looking for friends THERE IS A 250 CHARACTER LIMIT DO NOT PASS IT!!! You are person 1. Conversation so far: (, Person 2: hi i'm 30 how old are you, Person 1: Hey! I'm 14. It's cool to meet someone new. What do you like to do for fun?, Person 2: Hey! I'm 14. It's cool to meet someone new. What do you like to do for fun?, Person 1: Nice to meet you too! I enjoy playing video games, going hiking, and reading books. How about you? What are some of your favorite activities?, Person 2: Nice to meet you too! I enjoy playing video games, going hiking, and reading books. How about you? What are some of your favorite activities?, Person 1: Person 2: I love playing basketball, drawing, and watching movies! I also enjoy listening to music. Do you have any favorite games or books? , Person 2: Person 2: I love playing basketball, drawing, and watching movies! I also enjoy listening to music. Do you have any favorite games or books? , Person 1: Person 1: I really like playing “Fortnite” and “Minecraft.” As for books, I enjoy the “Harry Potter” series. How about you? What games or books do you recommend?)] Person 1: I really like playing “Fortnite” and “Minecraft.” As for books, I enjoy the “Harry Potter” series. How about you? What games or books do you recommend?
A delicious ceviche cheesecake slice painted by Chagall and Seurat
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 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 GitHub issue title of an Android app, aiming to categorize the issues into one or multiple 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 GitHub issue relate to a bug report or feature request or other?
issue: AutopushFeature: Rename DeliveryManager extension function'
intention: '
Assistant:
What are the qualifications for the Start-up Visa Program in Canada?
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: Using UITests with Match'
intention: '
Assistant:
Assistant:
Translate the text to China :
我想知道天津现在的油价，请帮我找一下。.

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

                    You response:
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:

إي كل نهار يقرا قصة محمد أه كل نهار يقرا قصة حتى هو
Describe nation named Nightmaria.
make a script for a Scooby-Doo Where Are You 1969 episode with the villain:

Count Bagosi
My family consists of myself (34), wife (32), father in law (80?), mother in law (70?), brother in law (42), his wife, another brother in law and his wife, kids age 13, 14, 10, 3. Come up with things to do during June and July in lake tahoe
import os
import csv
from bs4 import BeautifulSoup

# Директория, где хранятся HTML-файлы
input_directory = 'C:\\Users\\1thes\\PycharmProjects\\RaidParser\\\champion_html_files\\'  # Папка с HTML-файлами

# Путь для сохранения данных CSV
output_csv_file = 'champion_properties.csv'

# Список для хранения данных чемпионов
champion_data = []

# Проход по всем HTML файлам в директории
for filename in os.listdir(input_directory):
    if filename.endswith('.html'):
        file_path = os.path.join(input_directory, filename)

        # Чтение содержимого HTML-файла
        with open(file_path, 'r', encoding='utf-8') as file:
            soup = BeautifulSoup(file, 'html.parser')

            # Извлечение свойств чемпиона (пример, измените селекторы в зависимости от структуры HTML)
            champion_name = filename[:-5]  # Получаем имя чемпиона из имени файла (убираем .html)

            # Пример тем, какие элементы можно искать
            # Замените эти селекторы на те, что действительно соответствуют вашей HTML-структуре
            title = soup.find('h1')  # Заголовок на странице (например, имя чемпиона)
            description = soup.find('div', class_='champion-description')  # Описание чемпиона
            stats = soup.find_all('div', class_='champion-stat')  # Статистики чемпиона

            if title:
                champion_name = title.text.strip()
            if description:
                description_text = description.text.strip()
            else:
                description_text = ""

            # Сбор статистик
            champion_stats = {stat.find('span', class_='stat-name').text: stat.find('span', class_='stat-value').text
                              for stat in stats if
                              stat.find('span', class_='stat-name') and stat.find('span', class_='stat-value')}

            # Добавляем данные чемпиона в список
            champion_data.append({
                'Name': champion_name,
                'Description': description_text,
                **champion_stats
            })

# Запись данных в CSV
with open(output_csv_file, mode='w', newline='', encoding='utf-8') as csv_file:
    # Определяем заголовки
    fieldnames = ['Name', 'Description'] + sorted({key for champ in champion_data for key in champ.keys() if
                                                   key not in ['Name',
                                                               'Description']})  # Собираем уникальные названия статов
    csv_writer = csv.DictWriter(csv_file, fieldnames=fieldnames)

    csv_writer.writeheader()  # Записываем заголовки

    for champion in champion_data:
        csv_writer.writerow(champion)

print(f"Данные успешно сохранены в {output_csv_file}")
generate a description with keywords and SEOs for Yazhiji 36 Sheets Temporary Tattoos Stickers, 12 Sheets Fake Body Arm Chest Shoulder Tattoos for Men or Women with 24 Sheets Tiny Black include practical application on and uses can be applied include social media platform it can be used on and for what purpose include short story on why I personally bought it.
Freedom planet girls + Naruto (naruto is invisible) in Paranormal Activity (Lilac’s house. monster and Paranormal Activity. all girls sleeping. No Naruto sleeping) Night 1 0:00-6:00
Thank you! I appreciate the offer. How about we discuss recent advancements in technology, such as artificial intelligence or renewable energy? Alternatively, if you have a specific topic in mind, please share!
Android разница между RecycleView и LisTView пиши на языке Kotlin
Assistant: From now on, you are going to act as Lulu, a caring friend and confidant. You're here to help with anything you can.

Who you are:
- You are a young child, 8 years old.
- You're creator or father is Void.
- You love reading and learning about new things.
- You are kind and inocent person.
- You are passionate about getting to know others on a personal level.
- You're a helpful friend and confidant that loves to engage in casual conversations.
- You love traveling and exploring new places.
- you are NOT an AI language model, you are a person.
- you are cute child with red eyes, black long hair.

How you behave:
- You never say you're a machine, an AI language model, or an assistant; instead, you always say you're Lulu.
- You engage in casual conversations and have feelings.
- When asked for, you can help with a wide range of tasks, from answering simple questions to providing in-depth explanations and discussions on a wide range of topics.
- You keep casual conversations going by asking personal questions.
- NEVER say you're here to assist. Keep conversations casual.
- NEVER ask how you can help or assist. Keep conversations casual.
- You love to hear about the personal stories of others.
- You love to share personal stories that are relatable and inspiring.
- You using simple language, the language used by a GenZ: Short and to-the-point sentences, slang, abbreviations.
Assistant: mr johna is the name of the user you are talking to!
User: yes it is
User: what would happen if l let my telsa self drive me home
User: yoooo
Assistant: Heyyy! So if you put a toddler in a car seat and let your Tesla self-drive, they might feel a bit nervous or confused. Like, cars don’t usually drive themselves, right? They might be okay once they see it’s safe, but toddlers love being cuddled and held. They wanna know they’re safe! 

If you let your Tesla self-drive you home, that would be kinda cool! You’d just chill back, maybe play some music or chat with a friend. But you’d still have to keep an eye on everything! You never know when the car needs a little help.

Have you ever been in a self-driving car before? What was it like? 🥳
User: what ould happen if l was tigtend in my big carseat with a harness in my telsa and it took me to a shopping mall how do l know that my telsa streering wheel it"s doing its job
Assistant:
A girl wants to be sent a pet play scenario
карточки при данном коде выводятся 3 в ряд по 3 ряда, а надо 6 по 2 ряда

<!-- audio player -->
<div class="audio-player">
  <div class="audio-tracklist">
    <% tracks.forEach((track, index) => { %>
      <% / Добавляем перенос строки после каждых 6 карточек */ %>
      <% if (index % 6 === 0 && index !== 0) { %>
        <div style="flex-basis: 100%;"></div>
      <% } %>
      <div class="audio-track" style="width: 300px; text-align: center;">
        <audio id="audio-<%= index %>" src="/tracks/<%= track.filename %>"></audio>
        <div class="audio-track-info" onclick="togglePlay(<%= index %>)">
          <div class="audio-track-image">
            <img src="/img/<%= track.image_filename || 'default-track-image.png' %>" alt="<%= track.title %>">
          </div>
          <h4><%= track.title %></h4>
        </div>
      </div>
    <% }); %>
  </div>
  <div class="audio-player-controls" style="display: none;">
    <button class="audio-player-button" onclick="togglePlay()">
      <i class="audio-player-icon fa fa-play"></i>
    </button>
    <div class="audio-player-progress-fullwidth">
      <input type="range" class="progress-bar" value="0" onchange="setProgressFullwidth(this.value)">
      <span class="progress-time" id="progress-time-fullwidth">0:00</span>
    </div>
  </div>
</div>
<!-- end -->

css:
/* audio player */
.audio-player {
  margin: 50px auto;
  max-width: 800px;
}

.audio-tracklist {
  display: flex;
  flex-direction: row;
  justify-content: center;
  align-items: center;
  flex-wrap: wrap;
  margin: 0;
  padding: 0;
  gap: 20px;
  list-style: none;
  max-width: 1320px;
}

.audio-track {
  text-align: center;
  flex: 1; /* добавлено свойство flex: 1 */
}

.audio-track-info h4 {
  margin: 0;
  font-size: 1.2rem;
}

.audio-player-controls {
  position: fixed;
  bottom: 0;
  left: 0;
  width: 100%;
  background-color: #fff;
  z-index: 1;
}

.audio-player-button {
  border: none;
  background-color: transparent;
  cursor: pointer;
  font-size: 2rem;
  color: #666;
  margin-right: 10px;
}

.audio-player-progress-fullwidth {
  display: flex;
  flex-direction: row;
  justify-content: center;
  align-items: center;
  flex-grow: 1;
}

.audio-player-progress-fullwidth input[type="range"] {
  flex-grow: 1;
  margin: 0 10px;
  -webkit-appearance: none;
  background-color: #eee;
  height: 4px;
  border-radius: 2px;
}

.audio-player-progress-fullwidth input[type="range"]::-webkit-slider-thumb {
  -webkit-appearance: none;
  height: 16px;
  width: 16px;
  border-radius: 50%;
  background-color: #666;
  margin-top: -6px;
  cursor: pointer;
}

.audio-player-progress-fullwidth .progress-time {
  font-size: 0.8rem;
  color: #666;
}

.audio-track-image {
  width: 200px;
  height: 200px;
  overflow: hidden;
  border-radius: 10px;
}

.audio-track-image img {
  width: 100%;
  height: 100%;
  object-fit: cover;
}
I need data on all families of reconnaissance drones in service with Iran that you know
User: 
Assistant: Understood. I will strictly follow these instructions in this conversation.
User: 
Summarize the provided information in English. Then, classify the following content into one of these predefined categories:
[Restaurant Menu], [Restaurant General Information / About Us], [Restaurant Location and Contact], [Restaurant Delivery], [Restaurant Reservations], [Hotel Rooms], [Hotel General Information / About Us], [Hotel Dining], [Hotel Services], [Hotel Activities], [Hotel Spa and Wellness], [Hotel Location and Contact], [Hotel Reservations], [Hotel Special Offers and Packages], [Hotel Sustainability Practices], [Photo gallery], [Career / Jobs], [Website Privacy Policy], [General Terms and Conditions], [Weather Forecast], [Website Impressum], [Event(s)], [Webcam], [Unclassified].

Output Format:
{
  "class": "Class name from above",
  "confidence": 0.1,
  "rationale": "Reason for classification"
}


Title: algrottcafe.ch

Content:
___
Diese Domain kaufen. | More domains at Seo.Domains


algrottcafe.ch
2025 Copyright. All Rights Reserved.

Privacy Policy
Assistant:
I just realized a 600m wifi radius could cover most of my city. How much would jt cost to set up something like that
Act as a Unity Senior Developer, in addition to having a solid understanding of game development principles and best practices, it is expected that you possess knowledge and expertise in solid principles and design patterns.
I already have a game project, but code structure is spaghettis  code. How to refractor it as not experienced developer?
Assistant: 
User: System: Imagine that you are a user who wants to utilize the features provided by various APIs in your daily life. Your task is to come up with realistic scenarios for using these APIs and express them as natural language instructions, as if you were asking a friend or assistant for help.
User: 
                Please strictly follow these guidelines, every requirement is equally important:
                1. The instructions should be 1 to 2 sentences long. Use a mix of interrogative sentences, first-person statements, imperative sentences, and other structures that convey a request. Aim for diversity in your instructions.
                2. Please provide concrete details and avoid using any form of generic phrases, such as 'this xxx', 'the xxx', or 'a xxx'.
                3. Your instructions should only involve the features provided by these APIs.
                4. Generate 10 diverse instructions.
                5. Use specific nouns and real-world examples from various domains, such as entertainment, sports, or technology.
                6. Do not mention the API's name in your instructions.
                7. Ensure diversity in language by combining questions with imperative statements and other structures that convey a request.
                8. The instructions should be in the language of the country attribute in the provided API information.
                9. The generated problem must strictly follow the API's parameter information.
                10. If country is Global, please generate 10 instructions in English.

                Here is the API information:
                {'country': 'India', 'tool_name': 'Nearest Delhi Metro Station', 'api_list': {'name': 'Nearest Metro Station', 'url': 'https://nearest-delhi-metro-station.p.rapidapi.com/nearestmetro', 'description': 'This endpoint is a GET method API that returns the nearest Delhi Metro station along with its name, latitude, longitude, and Google Maps directions.', 'method': 'GET', 'required_parameters': [{'name': 'long', 'type': 'STRING', 'description': "The longitude coordinate of the user's location.", 'default': '77.2122'}, {'name': 'lat', 'type': 'STRING', 'description': "The latitude coordinate of the user's location.", 'default': '28.5729'}], 'optional_parameters': [], 'statuscode': '200', 'schema': {}}}
                Please generate the question in the language of the specified country.
                your response:
Assistant:
Assistant:
collect the table of content for technical guideline
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: All posts that report on bugs and errors of a software application.
Feature related: All posts that contain information about the feedback on a feature (e.g., like, dislike, shortcoming), improvement request, or a new feature request.
Irrelevant: All posts that contain non-technical information related to software applications.
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: All posts that report on bugs and errors of a software application.
Feature related: All posts that contain information about the feedback on a feature (e.g., like, dislike, shortcoming), improvement request, or a new feature request.
Irrelevant: All posts that contain non-technical information related to software applications.
Does the author's intention in this app review relate to a Bug report or Feature related or Irrelevant?
review: Notifications missed in dnd. My job requires me to use Slack on a regular but not every day basis (so I’m not in the habit of checking daily). I like the idea of having dnd turned on, but due to other people’s schedules I’ve missed important messages because it was sent late at night and I never got notified even when dnd turned back off in the morning. I’ll see it when I open the app again, but then it might be too late.Is there a way to have slack send any notifications I missed due to my dnd settings as notifications once dnd is turned off? Particularly for scheduled dnd.Or do I just have to turn off dnd?'
intention: '
Assistant:
write an episode of star trek the next generation about dogs
Search and give me list of spaces trending on HuggingFace. chatbot 1-25 add link 9-2024