Databases
Get names of products in "Electronics" category
AskAI
Write a SQL query to return the names of all products in the "Electronics" category, given two tables - products and product_categories.
Find names of customers who have purchased products with a price greater than...
AskAI
This technical problem asks the reader to write a SQL query to find the names of all customers who have purchased products with a price greater than $10. The example input provides three tables - customers , products, and purchases - and the expected output is a list of customer names.
SQL Query to Join Two Tables on Column X
AskAI
Given two tables, A and B, write a SQL query to join them on column x.
Joining Tables on the id Column
AskAI
Given two tables, t1 and t2, write a SQL query to join the two tables on the id column. Return the id, name, and email columns.
Finding the Total Number of Products Ordered for Each Product
AskAI
This technical problem involves writing a SQL query to find the total number of products ordered for each product in a given database. The example input provided shows two tables - products and orders - and the expected output is a listing of the total number of products ordered for each product. In the example output provided, product A has a total of 5 products ordered, and product B has a total of 1 product ordered.
Find all rows in table A that have a corresponding row in table B
AskAI
Given two tables, A and B, this SQL query finds all the rows from table A that have a corresponding row in table B.
Customers Who Have Purchased Products With a Price Greater Than $10
AskAI
This technical problem involves finding the names of customers who have purchased products with a price greater than $10 using a SQL query. The input includes three tables: Customers, Orders, and Products. The output is a table with the customer id and name.
SQL Query to Find Most Common First Name
AskAI
To find the most common first name in a table of user data, write a SQL query that groups the data by first name and orders the results by the number of occurrences.
