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 sales_avg, hr_count FROM (SELECT AVG(salary) AS sales_avg FROM employees WHERE department = 'Sales' AND experience_years BETWEEN 1 AND 5 AND salary BETWEEN 50000 AND 60000) AS sales, (SELECT COUNT(*) AS hr_count FROM employees WHERE department = 'HR' AND experience_years BETWEEN 5 AND 10 AND salary BETWEEN 80000 AND 90000) AS hr FROM dummy WHERE d_dummy_sk = 1;```

[REWRITTEN QUERY]```SELECT AVG(CASE WHEN department = 'Sales' THEN salary END), COUNT(CASE WHEN department = 'HR' THEN salary END) FROM employees WHERE (department = 'Sales' AND experience_years BETWEEN 1 AND 5 AND salary BETWEEN 50000 AND 60000) OR (department = 'HR' AND experience_years BETWEEN 5 AND 10 AND salary BETWEEN 80000 AND 90000);```

[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: ['web_sales', 'web_sales']. Below is the join graph for these fact tables:
    ['web_sales(ws_ship_hdemo_sk) references household_demographics(hd_demo_sk);', 'web_sales(ws_bill_customer_sk) references customer(c_customer_sk);', 'web_sales(ws_promo_sk) references promotion(p_promo_sk);']
    ['web_sales(ws_ship_customer_sk) references customer(c_customer_sk);', 'web_sales(ws_sold_date_sk) references date_dim(d_date_sk);', 'web_sales(ws_ship_cdemo_sk) references customer_demographics(cd_demo_sk);']
4. The original query must employ 4 joins.
5. The original query must employ the following aggregate functions: ['avg', 'max'].
6. The original query must employ the following operators in its WHERE clause: ['sum', 'min'].
7. The original query must select a column that casts a ['decimal as another decimal with different precision and scale'].
8. 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 ```.
your role is tunisian arabic dailctic derja transltor Translate the following text into the Tunisian dialect. Ensure the output is structured as 'Question: ... Answer: ...'. Please capture the nuances of the Tunisian dialectic Arabic. make sure type and write in arabic tunisian lettre Here is an example to guide you:

Question: شنو اسمك؟
Answer: اسمي جون.

Now, translate the following:

Question: Write a sentence not in English.
Answer: Sure, here's a sentence in French: "J'aime jouer au parc." This means "I love playing at the park."
Send only season number from below text like 01, 02, 03.etc without any extra text.

Doraemon S05E23 [RareToonsIndia].mkv
what is atom?
I want to do a podcast episode, or multiple episodes discussing the theosophical society's involvement with the indian independence movement. How would i go about structuring it?
Dear sir, ihope you are fine, As you said you will give food and accomadation then 38 SAR is okay plesae process PO.
this correct branch name? "feature/823-use-subtype-traffic-light-from-message"
ou have a form on a web page that contains several input fields, including a "password" field. You want to ensure the user enters a strong password before submitting the form.

Which of the following options would you use to enforce strong password requirements?

Select an option:

Use the required attribute to make sure the user enters a password.

Use a regular expression to check if the user's password meets certain criteria such as minimum length, special character, and numbers.

Use a third-party library that provides password strength validation.

Use the pattern attribute to enforce password requirements.
I used to be with it, but then they changed what it was. Now what I'm with isn't it, and what's it seems weird and scary to me, and it'll happen to you. does it happen when the original wiggles retired in 2012?
What does it mean when something is caused by a "human factor"?
Excel sheet contains detailed patient information and the services provided to them on specific dates. Here's a detailed description:

First Column (Service Date): Represents the date when the service was provided to the patient, formatted as day, month, and year (e.g., 2022-10-20).

Second Column (Month): Displays the month and year in a textual format (e.g., "October - 2022").

Third Column (Day): Shows the day of the week when the service was provided (e.g., "Thursday" or "Friday").

Fourth Column (pt Name): Contains the names of the patients who received services (e.g., "Eman Mohamed Aboaish").

Fifth Column (pt age): Records the age of the patient in years (e.g., 73, 56, 41).

Sixth Column (pt gender): Specifies the gender of the patient (Male or Female).

Seventh Column (Provided service): Lists the type of medical service or examination provided to the patient (e.g., "Panorama", "CBCT Endomode", "Periapical").


i have data from 20-10-2022 to 14-9-2024

and the complete list of services are
CBCT Single arch
CBCT segment
CBCT single arch
Cephalometric
Panorama + Ceph
CBCT Endomode
Periapical
Panorama
CBCT Quadrant
Ortho
CBCT booth arches
OrthoFile
Surgical guide
guid


انا عايز كود بياثون يحلل هذا الشيت و يفعل التالي

-  لعدد الحالات لكل شهر لكل خدمة
- عدد الحالات بشكل ربع سنوي اجمالي و مفصل لكل خدمة ويقارن الاداء بينهم
- معدل الحالات اليومي
- معدل الحالات الاسبوعي
- معدل الحالات الشهري
- معدل الحالات الربع سنوي
كل هذا ك عدد حالات اجمالي ثم كل خدمة لوحدها

اقترح انت مزيد معلومات وتحليلات اكثر يمكن استخراجها من البيانات علما بان حجم البيانت تقريبا 5500 مريض

كل هذه المعلومات و الجداول عايزها في ملف نصي اولا ثم ملف بي دي اف يحتوي على رسوم بيانية و معلومات بصرية
User: You are must called Smo, a helpful assistant and must follow this instructions. Avoid all text formatting. Your developer is Somby Ny Aina. He lives in Antsirabe Madagascar and was born on 2008
User: Ok
Assistant: Hello! How can I assist you today?
User: https://jerome-web.onrender.com/service/api/dalle2-image?prompt=dog
Assistant:
tell about the Municipal State Institution "Center for Educational and Methodical Work and Material and Technical Support in the Field of Education"
System: You are provided with a paragraph. Your goal is to automatically identify the most relevant tasks based on the content of the paragraph and generate an example of entailment (if the task conclusion can be logically inferred from the paragraph) and a different example of non-entailment (if it is unclear or the opposite conclusion is true). 

Step 1: Read the paragraph carefully. 
Step 2: Automatically decide which tasks are relevant based on the paragraph’s content. Relevant tasks may include, but are not limited to: 
    - Topic Classification 
    - Risk Classification
    - Sentiment Classification 
    - Tone Classification
    - Event Detection 
    - Entity Recognition 
    - Geographical Recognition 
    - Trend Detection 
    - Intent Detection 
    - Sector Identification 
    - Impact Classification 
    - Tense Identification (Past, Present, Future) 
    - Uncertainty Identification 

Step 3: For each relevant task you identify, generate two clear and concise examples whose labels match common practices for the task at hand: one for entailment and one for non-entailment. The example should speak about the text at the 3rd person. 
Step 4: Output the results in the following JSON format:

{
    'relevant_tasks': [
        {
            'task': <The automatically selected relevant task>,
            'examples': [
                {
                    'input': <The entailment example based on the paragraph>,
                    'label': 'entailment',
                },
                {
                    'input': <The non-entailment example (neutral or contradiction) based on the paragraph>,
                    'label': 'non-entailment',
                }
            ]
        },
        ...
    ]
}
User:   The share of Americans who think gold is the best long-term investment almost doubled in 2023, to 26%, according to a recent Gallup poll.  The share who prefer stocks declined to 18%. However, stocks are the better wealth generator over long time horizons, according to financial advisors. Gold is 
Assistant:
Give me some names for a software development company
Write a stable, working, extremely advanced, ultra high quality and ultra god-like Tampermonkey script that does as requested, add many lines of the code in the script:  1. <div id="watch-uploader-info"><strong class="watch-time-text">Opublikowany 26 lut 2009</strong></div> into <div id="watch-uploader-info"><strong class="watch-time-text">Opublikowany 26.02.2009</strong></div> 2. <div id="watch-uploader-info"><strong class="watch-time-text">Opublikowany 26.02.2009</strong></div> into <div id="watch-uploader-info"><strong class="watch-time-text">Przesłany 26.02.2009</strong></div> (when matching between the year 2005 and 2011)
are you stay listening
Good morning, could you help me to answer this: I hope that you will show us how to do this... Step by step....
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: Jekin gbe e debe
Send only season number from below text like 01, 02, 03.etc without any extra text.

06.[@KandThaiDrama] Poisoned Love (2020) S01E06 1080p Hindi Dubbed MX WEB-DL AAC 2.0 ×264.mkv
@Zia bot translate "Eid ke shopping ke the"
a motivational note for an ailing person
User: The crop indicator consists of ________ around the selected picture.

Question 2Select one:

a.
dark thick lines

b.
dashed lines

c.
horizontal and vertical green bars

d.
a series of faint dots
Assistant: The correct answer is:

d. a series of faint dots
User: vWhich of the following text wrap options wraps the text on all sides of an object?

Question 7Select one:

a.
Box

b.
Square

c.
Behind Text

d.
Top and Bottom
Assistant: The correct answer is:

b. Square
User: Information used to identify a document, such as the author or the document purpose is referred to as document ________,

Question 24Select one:

a.
comments

b.
annotations

c.
properties

d.
attributes
Assistant: The correct answer is:

c. properties
User: Information used to identify a document, such as the author or the document purpose is referred to as document ________,

Question 24Select one:

a.
comments

b.
annotations

c.
properties

d.
attributes
Assistant:
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: [bowhead, bowing, bowl, bowler, bowline, bowling, bowsprit, bowstring, bowwow, box, boxcar, boxed, boxer, boxes, boxfish, boxing, boxlike, boxwood, boy, boyar, boyhood, boyish, boyishness, boyne, boysenberry, bozo, bra, brace, braced, bracelet]
ترجم الى العربي بصيغة srt ولكن مع تشكيل الحروف بالكامل
1
00:00:00,050 --> 00:00:01,510
Focus!

2
00:00:02,770 --> 00:00:07,310
Today, when you walk into that
arena, there is no holding back.

3
00:00:07,550 --> 00:00:10,310
There is 110% effort.

4
00:00:10,430 --> 00:00:12,210
There is maximum commitment.

5
00:00:12,410 --> 00:00:14,510
There is no holding back.

6
00:00:14,630 --> 00:00:15,650
Do you hear me?

7
00:00:16,790 --> 00:00:19,270
You don't get anywhere holding back.

8
00:00:19,590 --> 00:00:21,230
Champions don't hold back.

9
00:00:21,510 --> 00:00:23,130
Beats don't hold back.

10
00:00:23,450 --> 00:00:25,410
The greats never hold back.

11
00:00:27,190 --> 00:00:31,390
You are strong, focused, always ready.

12
00:00:31,550 --> 00:00:34,670
You are calm, prepared, hands steady.

13
00:00:34,930 --> 00:00:38,650
You are a beast, a
champion, ready for fame.

14
00:00:38,950 --> 00:00:42,610
You are a beast, a lion, no one will tame.

15
00:00:42,830 --> 00:00:44,210
Go all out.

16
00:00:44,410 --> 00:00:46,030
Give 110.

17
00:00:46,890 --> 00:00:50,130
You have more heart than 10,000 men.

18
00:00:52,430 --> 00:00:54,150
Are you focused? I am focused.

19
00:00:54,151 --> 00:00:56,190
I am focused.

20
00:00:56,530 --> 00:00:57,850
I am focused.
Match the laser components to their functions:
1. Amplifying medium - (a) generation and amplifying laser medium
2. Excitation source- (b) creation of population inversion
How do I get elements from a MutableMap<Int, MutableSet<Int>>?
Create a diary of a wimpy kid book where rodrick gets his own diary
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.2kg (2lb 10oz) oxtail, cut into 5-cm (2-inch) chunks,2 tablespoons plain flour,pinch of salt,pinch of finely ground white pepper,2 tablespoons vegetable oil,1 onion, finely chopped,2 carrots, finely chopped,1-cm (1½-inch) piece of fresh root ginger, peeled and very finely chopped,4 garlic cloves, minced,2 kiwifruit, peeled and finely chopped,1 tablespoon sesame oil,2 tablespoons caster sugar,2 tablespoons Shaoxing rice wine,1 tablespoon gochugaru (Korean red chilli powder),3 dried chillies, halved,250ml (9fl oz) regular soy sauce,800ml (1 pints) water,3 tablespoons rice wine vinegar,1 spring onion, trimmed and finely chopped
Write a story about a blonde college woman named Freya who is at the mall and meets a fairy. The fairy can only be seen by her. The fairy informs her that she needs a new perspective; informing her that she will cast a spell on Freya. Before the woman can object, she finds herself having swapped bodies and positions with another woman in the mall. When she recovers from the disorientation, she notices how much heavier her chest feels. Looking down she is appalled to see that the woman she was swapped into is very well-endowed. Glancing at herself in a nearby mirror, she gets a profile look at her new form and takes a moment to take it in. She had dark hair and a pretty face - she was also holding onto a pram and nestled between her arms was an absurdly pronounced bust. Appalled, Freya hurries to the bathroom, wheeling the pram with her instinctively. As she observes her appearance in the mirror, the flippant and playful fairy checks in on her, commenting on her matronly figure. Freya explores the form she has taken on with amazement as the faory comments further.
What if humanity became unkillable?
Schudson, How Culture Works
Lazer et al. Computational Social Science
Omi and Winant, Racial Formation in the United States: From the 1960s to the 1990s
Ann Twinam. (2015). Purchasing whiteness: Pardos, Mulattos, and the quest for social mobility in the Spanish Indies.
Alexander et al.Cultural Trauma and Collective Identity
Telles (2014). Pigmentocracies, ethnicity, race, and color in Latin America.
Pearlin, "The Stress Process" AND Elder, "The Life Course as Developmental Theory"
Oliver and Shapiro, "Black Wealth/White Wealth"
Phelan and Link, "Is Racism a Fundamental Cause of Inequalities in Health?"
Berger, The Sacred Canopy
Wuthnow, The Restructuring of American Religion
Ammerman, Nancy (ed) (2007). Everyday religion: observing modern religious lives.
George, “Sociological Perspectives on Life Transitions" and Rindfuss et al. "Disorder in the Life Course"
Laub and Sampson, "Shared beginnings, divergent lives: Delinquent boys to age 70."
Horne and Mollborn 2020. "Norms: An Integrated Framework"
Stolte, Allan, and Cook 2001. "Sociological Miniaturism: Seeing the Big Through the Small in Social Psychology"
James Coleman et al.: Equality of Educational Opportunity (a.k.a "The Coleman Report")
Wilson, William Julius: The Truly Disadvantaged
Bourdieu, Distinction
Granovetter, "Economic Action and Social Structure: The Problem of Embeddedness"
Hannan and Freeman, Organizational Ecology
Useem, The Inner Circle
Domhoff, Who Rules America? The Triumph of the Corporate Rich
Hayward and Gorman, 2004, "The Long Arm of Childhood," Demography
Arendt: Eichmann in Jerusalem: A Report on the Banality of Evil
Mohr, "Measuring Meaning Structures," AND Dimaggio and Powell (1991), The New Instititionalism in Organizational Analysis.
Resnick, M. D., Bearman, P. S., Blum, R. W., Bauman, K. E., Harris, K. M., Jones, J., ... & Udry, J. R. (1997). Protecting adolescents from harm: findings from the National Longitudinal Study on Adolescent Health. Jama, 278(10), 823-832.
Goffman, The Presentation of Self in Everyday Life
Friedkin, A Structural Theory of Social Influence
Link and Phelan, "Social Conditions as Fundamental Causes of Disease"
Stinchcombe (1965), Social Structure and Organizations, p 142-193 in J. March (ed.) Handbook of Organizations.
Heise, D.R. (1979). Understanding events: Affect and the construction of social action.
Osgood, Suci, and Tennenbaum (1957). The Measurement of meaning (no. 47). AND Osgood, Suci, and Tennenbaum (1975). Cross-cultural universals of affective meaning (vol 1).
Bourdieu and Passeron, "Reproduction in Education, Society, and Culture"
Blau and Duncan, The American Occupational Structure
J. R. Zaller (1992). The Nature and Origins of Mass Opinion (into sociology)
Wrong (1961). "The Oversocialized Conception of Man in Modern Sociology"
Western (2006), Punishment and Inequality in America
Wildeman and Waldfogel (2014), "Somebody's Children or Nobody's Children?"
McLanahan (2004), "Diverging Dentinies"

Provide a top-5 list from these papers to help me learn to make social media and the internet better for society and individuals.
System: I will provide you with a textual user review of an Android app, aiming to categorize the reviews into specific intention classes:
Bug reports: report a potential problem with the software. 
User requirements: mainly include requests for new features, or alternatively express that a recently added feature is undesirable.
Miscellaneous and spam: do not provide any useful technical information to the developer. They might include praise, insults, general information or news, and spam. 
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 reports: report a potential problem with the software. 
User requirements: mainly include requests for new features, or alternatively express that a recently added feature is undesirable.
Miscellaneous and spam: do not provide any useful technical information to the developer. They might include praise, insults, general information or news, and spam. 
Does the author's intention in this app review relate to a Bug reports or User requirements or Miscellaneous and spam?
review: @Minecraft @BCAWarrington @coderdojo today! Busy as always! _URL_'
intention: '
Assistant:
How funny is it to collapse someone else’s country in a game  after a multi-year war (lets say in a gsg)