Replication
Multiplying Values in Two Tables
AskAI
You are given two tables, Table A and Table B. Your task is to write a SQL query that returns the sum of the values in Table A, multiplied by the sum of the values in Table B.
SQL Query to Find Top 10 Customers by Total Spent
AskAI
Write a SQL query to find the top 10 customers by total spent.
Replicating a Database Across Multiple Servers
AskAI
To replicate a database across multiple servers, you would need to set up a master server with the database, and then set up replication on the other servers. This would allow the other servers to have copies of the database, which would be updated whenever the master server's database is updated.
Find the average order value for each customer.
AskAI
This technical problem asks the reader to write a SQL query to find the average order value for each customer, given a table of customer orders. An example input and output is provided.
Find the id of the row with the maximum value
AskAI
The problem is asking for the id of the row with the maximum value in a table with two columns, "id" and "value". An example input and output is given.
SQL Query to Find All Parents Who Have at Least One Child
AskAI
This technical problem deals with writing a SQL query to find all parents who have at least one child. The example input and output are provided in the body of the problem.
Find all employees who work in the Sales department.
AskAI
Given a database with two tables, Employees and Departments, this SQL query will find the names of all employees who work in the Sales department.
Get names and total spending for customers who have made a purchase in the...
AskAI
This technical problem asks the reader to write a SQL query that returns the names and total spending for customers who have made a purchase from the store in the last 30 days. The input is provided in the form of two tables, customers and orders, and the output is expected in the form of a table with two columns, name and total_spent.
