Databases
Get list of customers who have purchased products from the "Bikes" category,...
AskAI
Get list of customers who have purchased products from the "Bikes" category, including the customer's first and last name, as well as the total amount spent on products from the "B ikes" category.
Joining two tables in SQL
AskAI
Write a SQL query to join two tables - Table A and Table B - and return all rows from both tables.
Joining Tables - User Purchases
AskAI
This technical problem involves joining two tables of data - one containing information on users, and the other containing information on user purchases. The goal is to write a SQL query that returns the total amount spent by each user.
Find the total number of orders per customer.
AskAI
This technical problem involves writing a SQL query to find the total number of orders per customer, given two tables: "customers" and "orders".
Find all artists with at least one track
AskAI
Given two tables, track and artist, this SQL query returns the names of all artists who have at least one track on the track table.
"Finding People in Common Between Two Tables"
AskAI
This technical problem deals with finding people who are in both of two given tables, A and B. The expected output is a list of the names of those people.
SQL Query to Join Two Tables
AskAI
Given two tables, this SQL query will find all the rows in the first table that have matching values in the second table.
Get product and category info from two tables
AskAI
Given two tables, products and categories, write a SQL query that returns all products with their corresponding category names.
