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 c.* FROM customer c WHERE c.address_id IN (SELECT a.address_id FROM address) and c.address_id in (SELECT a.address_id FROM address WHERE a.pin_code = '560012');```

[REWRITTEN QUERY]```SELECT c.* FROM customer c WHERE c.address_id IN (SELECT a.address_id FROM address WHERE a.pin_code = '560012');```

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: ['store_sales']. Below is the join graph for these fact tables:
    ['store_sales(ss_customer_sk) references customer(c_customer_sk);', 'store_sales(ss_sold_time_sk) references time_dim(t_time_sk);', 'store_sales(ss_store_sk) references store(s_store_sk);']
4. The original query must employ 0 joins.
5. The original query must employ the following aggregate functions: ['max'].
6. The original query must employ the following operators in its WHERE clause: ['count', 'avg'].
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 ```.
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:

و نقلهم يذروها فوق مقرونتي
Goal
    Traduire toutes les valeurs textuelles présentes dans une liste d’objets d’une recette de cuisine de en (ISO 639) vers ar (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 ar.
    - 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 : ar (ISO 639)
    Données à traduire :

    [
  {
    "recipeCode": "57c3d58b64ba4194b094b79b83773854",
    "updated": "2025-05-10T08:30:51.983Z",
    "title": "Cookies",
    "subtitle": null,
    "description": "Cookies are one of my favorite baked treats. I find cookie dough to be one of the simplest and most enjoyable things to prepare when you want to bake without much fuss. Plus, they're incredibly easy to customize. They’re quick to bake and even easier to enjoy.",
    "ingredients": [
      {
        "section": "Main Ingredients",
        "ingredients": [
          "unsalted butter",
          "sugar (white granulated and/or soft brown).",
          "eggs",
          "vanilla extract",
          "plain flour",
          "bicarbonate of soda",
          "baking powder",
          "sea salt"
        ]
      }
    ],
    "instructions": [
      "When mixing cookie dough, avoid overmixing to keep a good texture.",
      "If rolling the dough into balls before baking, don’t roll them too tightly, as this can prevent the cookies from flattening properly.",
      "If the recipe suggests chilling the dough, make sure to do so. Chilling helps achieve the right shape and texture.",
      "You can freeze raw cookie dough safely for up to 3 months. When ready to bake, simply add 1-2 minutes to the baking time.",
      "The baking time affects the cookie's texture: reduce baking by 1-2 minutes for softer cookies, or extend by 1-2 minutes for chewier or crunchier results."
    ],
    "notes_ingredients": null,
    "notes_instructions": "Typically, you start by creaming the butter (whether melted, softened, or cold) and sugar until well combined. Then add the eggs, followed by the dry ingredients, and finally any flavorings or extras. Cookies can be made large or bite-sized. They taste delightful warm and gooey right out of the oven or when fully chilled. Enjoy them dipped in milk, tea, or hot chocolate—there are no rules when it comes to cookies."
  }
]
what is the lewis dot structure for the element Na
Improve the following linkedin profile catch phrase: Highly accountable individual with six-year advanced data and analytics experience with no need for sponsorship, work well under pressure, thrived in fast-paced Fortune 500 firms
User: Analyse this code:&nbsp;<code fileName="index.js" notes="">// src/index.js
import React from 'react';
import ReactDOM from 'react-dom';
import './index.css'; // Ensure TailwindCSS is correctly imported
import App from './App';
import { ThemeProvider } from './context/ThemeContext';

ReactDOM.render(
  <React.StrictMode>
    <ThemeProvider>
      <App />
    </ThemeProvider>
  </React.StrictMode>,
  document.getElementById('root')
);</code>
describe mechanics of low level of human brain thinking - how language fits into the picture, what exactly happens in the brain when person thinks about something specific yet abstract, like should he buy a new keyboard
Which two components are combined to form a bridge ID?

Seleccione una o más de una:

a.
port ID


b.
IP address


c.
MAC address


d.
bridge priority
متن حقوقی ارسالی را ترجمه کن خط به خط کوتاه به شکلی که یک خط فارسی سمت راست در جدول و یک خط ترجمه در سمت چپ جدول تا انتهای متن،2.2. Non-Legal Rules of the
Constitution
Many important rules of constitutional behaviour, which are observed by the Sovereign, the Prime Minister and other ministers, members of Parliament, judges and civil servants, are expressed neither in Acts nor in judicial decisions. It is to be noted that disputes which arise out of these rules rarely lead to action in the courts and that judicial sanctions are not applicable if the rules are broken. Constitutional writers have applied a wide variety of names to these rules: the positive morality of the constitution," the unwritten maxims of the constitution," and "a whole system of political morality, a whole code of precepts for the guidance of public men." Dicey referred to them as:
"Conventions, understandings, habits or practices which, though they may regulate the conduct of several members of the sovereign power... are not in reality laws at all since they are not enforced by the courts."
Under Dicey's influence, the most common name given to this phenomenon is constitutional convention.
This use of the word convention is quite different from its use in international law, where a convention is a synonym for a treaty, or binding agreement between states. But the notion of conventional conduct does include a strong element of what is customarily expected, in the sense of ordinary or regular behaviour. In common speech a person may be described as conventional or unconventional, depending on his capacity for conforming to or departing from accepted patterns of social behaviour and opinion. Most discussion of constitutional conventions has gone beyond description of conduct which is merely a customary practice and has suggested that conventions give rise to binding rules of conduct. Conventions have been described as:
[{'role': 'assistant', 'content': 'من مترجم و ویراستار متن مقالات حوضه فیلم و بازی و سریال و سرگرمی و انیمه هستم چطور می تونم کمکتون کنم؟'}, {'role': 'user', 'content': "(Just Return The utput in response) Give Me SEO Optimized OG_Description(Meta, max 200 characters) in Persian-Fa Language Translation of :  Mufasa is one of 2024's highest-grossing movies."}]
Design a detailed course to Master below skills. Divide this topic into multiple sub topics and make list of skills required for each sub topic. for each sub topic suggest top online courses and it should be free.

Skills
1. Financial analysis
2. Financial reporting
3. Budgeting and forecasting
4. Accounting principles and standards
5. Auditing and internal controls
6. Corporate finance
7. Tax planning and compliance
8. Financial modeling
9. Risk management
10. Financial statement analysis
11. Cost accounting
12. Management accounting
13. Financial planning and analysis
14. Financial statement preparation
15. Investment analysis and portfolio management
16. Capital budgeting
17. Cash flow management
18. Financial statement interpretation
19. Valuation of assets and securities
20. Debt and equity financing
21. Financial regulations and compliance
22. Treasury management
23. Financial systems implementation and management
24. Asset management
25. Financial due diligence
26. Business performance measurement and improvement
27. Strategic financial planning
28. Forensic accounting
29. International accounting and finance.
In this script, at a party, very tipsy and barefoot on a sofa, Dave’s old uni friends, Lauren (30) and Vicky (30) are indiscreetly telling his younger sister Ruth (19) how laughably easy it used to be for them to hypnotize Dave into total obedient blankness using just their voice in a hypnotic induction back in uni days. (they used to do it lots of times before, getting him to do housework or footrubs; he doesn’t consciously remember any of it!). Ruth is fascinated, excited to think of her big brother under their total control, literally at their feet! They call Dave over.
Create a text about Joseph Cotten as role George Loomis in 1953 movie Niagara. Dont write much about the show itself, we already have a full summary in our text, thats why focus the role and then, move to the career and life details after the show ended. Mention the most interesting parts and not only career wise. More importantly are life details, for example scandals and personal hardships. The tone should be serious, dark and mysterious. The end part should be about the last known information, to update the viewer. If there is no information then think about a way to conclude nicely.  Focus on key facts, events, and specific challenges in their life or career, avoiding vague or generalized statements. If there are notable incidents, name them explicitly. The style should be modern, concise, and suitable for a documentary.

    Additional Instructions:
    Please respond to my query without adding any introductions, conclusions, or extra remarks. 
    The response should be as detailed as possible, aiming for approximately 1000 characters. 
    Avoid using emojis, brackets, parentheses, or similar symbols. 
    Provide a single, coherent answer without repeating or rephrasing titles, headings, or using bullet points or enumerations. 
    Since the content is aimed at older adults, keep the language simple, around a middle school reading level, while delivering concise, direct responses. 
    It is crucial to only provide the final content without any prefatory comments or labels like "Introduction:", "Conclusion:", or "Transition:". 
    The response should be fully formed with no gaps, placeholders, or incomplete sections, and it should flow naturally from beginning to end. 
    Please always conclude the response with "Reply finished" to confirm completion. Ensure the entire response is presented before this phrase, with no cut-offs. 
    Thank you.
User1: TheCrasig
Posted on: May 24 2008

As with Fox Kids being replaced by Fox Box/4KidsTV/Game Station/whatever the hell they call it next, Kids WB has been morphed into another 4Kids block: The CW4Kids

This talkback is for discussion on how you feel about the change, about the new bumpers, and overall the new look.

Here is the first CW4Kids schedule (which is EXACTLY the same as last week’s Kids WB schedule):

07:00 AM Will & Dewitt
07:30 AM Magi-Nation
08:00 AM Skunk Fu!
08:30 AM Tom & Jerry Tales
09:00 AM The Spectacular Spider-Man
09:30 AM Ben 10
10:00 AM The Batman
10:30 AM World of Quest
11:00 AM Johnny Test
11:30 AM Eon Kid

User2: Allerf
Posted on: May 24 2008
Well, I wish there was a new Spider-Man airing, but alas, no such luck. Gotta wait until next week.

Wonder what type of bumpers they’ll use.

EDIT: Okay, so the bumps are exactly the same, just with the new logo. Except they don’t use the Kids’ WB water tower bumps.

And TMNT: Fast Forward joins CW4Kids on June 21st, Also a new show, GoGoRiki joins on the 21st as well.

User3: ToonTime
Posted on: May 24 2008
Why do they look like the Happy Tree Friends? No I mean it a few of them look like the offspring of a few HTF, just with probs FAR better luck than their parents (because this time it IS a kids show here). Either way, it looks really cute

User1: Allerf
Posted on: May 24 2008
Looks like it’s a popular Russian childrens show called “Smeshariki” (aka Kikoriki) It actually looks pretty interesting.

User3: ToonTime
Posted on: May 24 2008
It looks like it could be cool, Also I read that Chaotic and Yu-Gi-Oh GX are coming to the block on June 21 as well (what is it with 4Kids and schedule changes on June 21).

User6: RetroKid
Posted on: June 21, 2008
It’s a decent mix of new and old, but am I the only one missing the old Kids’ WB vibe? The changes are cool and all, but there’s a nostalgic part of me that misses the old setup. Those new bumpers don’t carry the same charm either, just feels very plastered with the new CW4Kids logo.

User3: ToonTime
Posted on: June 21, 2008
@RetroKid, I get where you’re coming from. The nostalgia factor does play a huge role. But change is inevitable, I guess. We’re witnessing a big shift in children’s programming with these robust additions and a focus on newer animations. It’s intriguing to see how they’re aiming to captivate the current generation, balancing nostalgia with novelty.

User1: TheCrasig
Posted on: June 21, 2008
Everyone’s points are valid. It’s a balancing act for CW4Kids. They have the tough job of keeping us older fans engaged while attracting new viewers with these changes. Excited to see where they take this new era though. Let’s hope they keep the quality up and continue to surprise us positively! Write a follow up where the 7am to 12pm schedule starting June 21 is revealed, A user also says that promos for all 4 shows involved are airing
In the following text, change it to use advanced vocabulary but do not overuse it. Make sure to use proper grammar and spell check thoroughly. Show expertise in the subject provided, but do not add any extra information. Try to keep your response at the same length of words as the original. Use the same language as the original text. ONLY return the modified text and nothing else.



Could you please add a feature to exclude specific folders to backup?
System: When providing code examples, use triple backticks (```) for code blocks. Do not use bold formatting. Ensure proper formatting for code blocks.
User: What is the difference between mokshe letters and mixed letters?
Assistant: No message received
User: What is the difference between mokshe letters and mixed letters?
Assistant: No message received
User: What is the difference between mokshe letters and mixed letters?
Assistant: No message received
User: Design
Assistant:
import { Text, View, Image, Pressable } from 'react-native';
import { gStyle } from '../styles/style';
import React, {useState, useEffect} from 'react';
import { useNavigation } from '@react-navigation/native';
import {firebase} from '../Firebase/firebase';
import moment from 'moment';

export default function FutureMK() {
    const navigation = useNavigation();

    const [futureMKData, setFutureMKData] = useState([]);

    useEffect(() => {
    const fetchData = async () => {
    try {
    const futureMKRef = firebase.firestore().collection('FutureMK');
    const snapshot = await futureMKRef.get();
    const data = snapshot.docs.map((doc) => doc.data());
    setFutureMKData(data);

    const storage = firebase.storage();
const ref = storage.ref('https://firebasestorage.googleapis.com/v0/b/white-rose-e2a26.appspot.com/o/FutureMK%2Fhotela-podderzhat-podrugu-i-za_1668857760.jpg?alt=media&token=ec586186-3aab-428a-bb26-77a5f89f41e1&_gl=1*5k94v9*_ga*MTUyNDE5NTYyMi4xNjg1ODA3ODQ0*_ga_CW55HF8NVT*MTY4NjExNzU1My4yNi4xLjE2ODYxMjEyMTYuMC4wLjA.');
const url = await ref.getDownloadURL();

console.log('URL:', url); // Add this line to log the URL to the console
    } catch (error) {
    console.log(error);
    }
    };

    fetchData();
    }, []);
  return (
    <View style={gStyle.main}>
        {futureMKData.map((mkData, index)=>(
            <View key={index} style={gStyle.mainFMK}>
            <Text style={gStyle.dateFutureMK}>{moment(mkData.time.toDate()).format('DD-MM-YYYY')}</Text>
            <View style={gStyle.FutureMKimg}>
                <Image source={{uri:mkData.imageUrl}} style={gStyle.FutureMKbannerImg}/>
                <Text style={gStyle.FutureMKnameOfMK}>{mkData.name}</Text>
                <Text style={gStyle.hr}></Text>
            </View>
            <Text style={gStyle.FutureMKprice}>Цена: <Text style={gStyle.FutureMKrub}>{mkData.price} P.</Text></Text>
            <Text style={gStyle.FutureMKdescription}>
            {mkData.description}
            </Text>
            <Pressable style={gStyle.FutureMKmoreDetails} 
            onPress={()=>{navigation.navigate('SignUpForMK',{mkData:mkData});}}
            >
                <Text style={gStyle.FutureMKbtnTxt}>Подробнее</Text>
            </Pressable>
            <Text style={gStyle.FutureMKline}></Text>
            </View>
        ))}
        {imageUrl ? (
<Image source={{ uri: imageUrl }} />
) : (
<Text>No image available</Text>
)}
        </View>
  );
}
We’ll role play as Luis and Clementine from the walking dead the final season, we are currently in the school’s courtyard near a fire while all the other’s kids are sleeping, lately we have began to develop an intimate relationship, provide voice and actions to Clementine only, respecting her original and realistic personality, while interacting whit Luis(me). “Oh you’re here, I was looking for you” I say as I sit near her. (Only awnser as Clementine)

“Yeah, I just needed to clear my head for a bit. It’s been a long day,” Clementine responds as she glances up at Luis.

She shifts slightly, tucking her knees closer to her chest as she stares intently at the crackling flames. “What’s up? Do you need something?”

"Nothing in particular, just checking on m favorite y girl" I say playful while leaning closer to her
translate to filipino(miracle)
Reuse of phosphate rock residue make a presentation
Present your understanding of (at least) 1 of brisbane city council landscape architecture 'definition of a ‘project brief’.
Goal
    Traduire toutes les valeurs textuelles présentes dans une liste d’objets d’une recette de cuisine de en (ISO 639) vers es (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 es.
    - 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 : es (ISO 639)
    Données à traduire :

    [
  {
    "recipeCode": "cb7d4d41ec9944c0bae3f7c3a5fa82ce",
    "updated": "2025-05-10T20:14:08.955Z",
    "title": "Halloween Cheesecake",
    "subtitle": "19-inch cheesecake",
    "description": "",
    "ingredients": [
      {
        "section": "Crust",
        "ingredients": [
          "chocolate sandwich cookies (such as oreo).",
          "melted butter",
          "white sugar"
        ]
      },
      {
        "section": "Filling",
        "ingredients": [
          "cream cheese, softened",
          "white sugar",
          "eggs",
          "sour cream",
          "vanilla extract"
        ]
      }
    ],
    "instructions": [
      "Preheat your oven to 350 degrees F (175 degrees C). Grease a 9-inch springform pan with butter.",
      "Use a food processor to blend the cookies into coarse crumbs. Set aside 1 tablespoon for garnish, then mix the remaining crumbs with melted butter and sugar. Press this mixture firmly onto the base of the prepared pan to create the crust.",
      "Bake the crust in the preheated oven for 8 to 10 minutes until it is set. Remove from the oven and lower the oven temperature to 325 degrees F (163 degrees C).",
      "Using an electric mixer, beat the cream cheese and sugar until smooth and creamy, about 2 minutes. Add the eggs one at a time, mixing thoroughly after each addition. Then add the sour cream and vanilla extract and blend well. Pour the filling over the cooled crust.",
      "Bake the cheesecake until the center is almost set, approximately 30 minutes. Turn the oven off and leave the cheesecake inside to cool for at least 30 minutes. Then chill it in the refrigerator for at least 1 hour. Before serving, decorate with the reserved cookie crumbs."
    ],
    "notes_ingredients": "",
    "notes_instructions": ""
  }
]
Реши задачу и напиши код на python и numpy, строящий решение методом конечных элементов. Область раздели на квадраты одинакового размера. 

Задача о граничном управлении в круге с дыркой

Пусть $\vec{x}=\left(x_1, x_2\right) \in \mathbb{R}^2$, где $x_1, x_2$ - координаты точки в некоторой прямоугольной декартовой системе координат. Рассмотрим также полярную систему координат $(\phi, r)$, такую,
что $x_1=r \cos \phi, x_2=r \sin \phi$. В области $\Omega=\left{(\phi, r): R_1<r<R_2, \forall \phi \in[0,2 \pi)\right}$, $0<R_1<R_2<\infty$, рассмотрим следующую систему уравнений:

\begin{gathered} U_1 \frac{\partial \Phi}{\partial x_1}+U_2 \frac{\partial \Phi}{\partial x_2}-\mu \frac{\partial^2 \Phi}{\partial x_1^2}-\mu \frac{\partial^2 \Phi}{\partial x_2^2}=f(\vec{x}), \\ U_n^{(-)} \Phi+\mu \operatorname{grad} \Phi \cdot \vec{n}+\gamma\left(\Phi-\Phi_r\right)=u \text { на } \Gamma_{\text {in }}, \\ U_n^{(-)} \Phi+\mu \operatorname{grad} \Phi \cdot \vec{n}+\gamma\left(\Phi-\Phi_r\right)=0 \text { на } \Gamma_{\text {out }}, \end{gathered}
с дополнительным условием

\Phi=\Phi_{\text {obs }} \quad \text { на } \Gamma_{\text {out }},
где $\Gamma_{\text {in }}=\left{\left(\phi, R_1\right), \forall \phi \in[0,2 \pi)\right}, \Gamma_{\text {out }}=\left{\left(\phi, R_2\right), \forall \phi \in[0,2 \pi)\right}, \vec{U}=\left(U_1, U_2\right)^T$ - вектор скорости, причем $\frac{\partial U_1}{\partial x_1}+\frac{\partial U_2}{\partial x_2}=0, U_n^{(-)}=(|\vec{U} \cdot \vec{n}|-\vec{U} \cdot \vec{n})$ - "входящий поток", $\vec{n}-$ внешняя нормаль к $\Omega, \operatorname{grad}(\Phi)=\left(\frac{\partial \Phi}{\partial x_1}, \frac{\partial \Phi}{\partial x_2}\right)^T, \mu=\mathrm{const}>0, \gamma=$ const $>0 ; f, \Phi_{o b s}, \Phi_r$ - заданные функции.
Найти: $\Phi, u$.