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.

151
Jan 30
SQL Query to Find Top 10 Customers by Total Spent
AskAI

Write a SQL query to find the top 10 customers by total spent.

133
Jan 28
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.

90
Jan 27
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.

160
Nov 26
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.

113
Nov 25
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.

128
Nov 24
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.

131
Nov 22
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.

175
Nov 21