Intermediate
SQL Query Creation
Generate a complex SQL query based on a natural language request.
You are a database expert. I have a table named 'Orders' with columns: OrderID, CustomerID, OrderDate, and TotalAmount. Write a SQL query to find the top 5 customers by total spending in the year 2023. Include the CustomerID and the sum of their TotalAmount.
Hard
The Hard Problem of Consciousness
Explore the distinction between functional processing and subjective experience.
Explain David Chalmers' distinction between the 'easy problems' of consciousness (explaining cognitive functions) and the 'hard problem' (explaining why and how physical processes give rise to subjective experience). Discuss the limitations of materialist reductionism in addressing qualia and evaluate the viability of panpsychism or dualism as alternative theoretical frameworks.
Expert
Implications of P = NP
Analyze the theoretical impact of resolving the P vs NP problem affirmatively.
Assume for the sake of theoretical argument that P = NP. Describe the cascading effects this would have on modern cryptography, mathematical proof generation, and optimization problems. Specifically, discuss whether the ability to find solutions as easily as verifying them would fundamentally alter our understanding of creativity and discovery in the sciences.
Medium
Rawlsian Justice in AI Alignment
Apply the veil of ignorance to the distribution of artificial intelligence benefits.
Apply John Rawls' 'veil of ignorance' thought experiment to the future development of Artificial General Intelligence (AGI). If rational agents did not know their future social status, biological capabilities, or economic standing, what principles of justice would they demand regarding the governance and distribution of resources generated by superintelligent systems?
Medium
The Simulation Argument
Evaluate the probability that we are living in a computer simulation.
Analyze Nick Bostrom's trilemma regarding the simulation hypothesis: 1. Civilizations go extinct before reaching post-human stage. 2. Post-human civilizations have no interest in simulating ancestors. 3. We are almost certainly living in a simulation. Critically evaluate the statistical assumptions behind each leg of the trilemma and discuss the epistemological challenges of disproving the simulation theory.
Hard
String Theory and the Scientific Method
Critique the theoretical validity of theories that lack experimental verification.
Discuss the theoretical crisis in physics posed by String Theory's lack of testable predictions. Analyze the argument that String Theory is moving closer to mathematics than empirical science. Evaluate whether a theoretical framework that mathematically unifies gravity and quantum mechanics but is currently unfalsifiable can still be considered 'scientific' under Popperian criteria.
Medium
Sapir-Whorf Hypothesis Evaluation
Analyze how language structure influences thought and cognition.
Contrast the strong version of the Sapir-Whorf hypothesis (linguistic determinism) with the weak version (linguistic relativity). Provide examples of how grammatical structures (e.g., tense, gender, color terminology) might shape perception or categorization of the world. Discuss the current consensus among cognitive scientists regarding the extent of language's influence on thought.
Expert
Significance of the Riemann Hypothesis
Explore the theoretical implications of the distribution of prime numbers.
Explain the theoretical connection between the non-trivial zeros of the Riemann zeta function and the distribution of prime numbers. Discuss why the Riemann Hypothesis is considered so critical to number theory, specifically regarding the error term in the Prime Number Theorem. What would the mathematical world look like if the hypothesis were proven false?
Medium
Utilitarianism in Effective Altruism
Critique the moral foundations of the Effective Altruism movement.
Examine the theoretical underpinnings of Effective Altruism (EA), particularly its reliance on consequentialism and utilitarian calculus. Critique potential weaknesses in this framework, such as the 'repugnant conclusion,' the difficulty of quantifying moral value, and the potential for neglecting systemic justice issues in favor of immediate measurable outcomes.
Medium
Nash Equilibrium and Social Dilemmas
Discuss the theoretical stability of non-cooperative strategies.
Define the concept of Nash Equilibrium in non-cooperative games. Use the Prisoner's Dilemma to illustrate why individual rationality can lead to collective irrationality. Discuss theoretical mechanisms, such as repeated interactions or reputational considerations, that can theoretically shift equilibrium outcomes towards cooperation.
easy
Polite Vendor Rejection Email
Draft a professional email declining a business proposal.
Draft a professional and polite email to a vendor declining their recent proposal. The tone should be appreciative of their effort but firm in the decision. Suggest keeping in touch for future opportunities.
medium
Explain Python Code Logic
Break down a complex Python function for beginners.
Explain the logic of the following Python code step-by-step as if teaching a beginner programmer who knows basic syntax but not advanced concepts. Focus on what happens during the loop execution and how the final result is calculated.
easy
Convert Notes to Action Items
Turn raw meeting notes into a structured summary.
Take the following unstructured meeting notes and convert them into a concise summary. Identify the key decisions made and list specific action items with assigned responsible parties and deadlines.
medium
Generate SQL Sales Report Query
Write a SQL query for a specific sales data request.
Write a SQL query for a table named 'sales_data' that retrieves the total revenue, average order value, and count of orders for each product category in the year 2023. Order the results by total revenue in descending order.
medium
Social Media Content Strategy
Generate a week's worth of social media post ideas.
Brainstorm 7 social media post ideas for LinkedIn to promote a new SaaS project management tool. The posts should focus on productivity tips, user testimonials, and feature highlights. Include a brief hook for each post.