## Replication

##### Multiplying Values in Two Tables

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.

245
Jan 30
##### SQL Query to Find Top 10 Customers by Total Spent

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

219
Jan 28
##### Replicating a Database Across Multiple Servers

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.

150
Jan 27
##### Find the average order value for each customer.

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.

249
Nov 26
##### Find the id of the row with the maximum value

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.

160
Nov 25
##### SQL Query to Find All Parents Who Have at Least One Child

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.

204
Nov 24
##### Find all employees who work in the Sales department.

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.

210
Nov 22
##### Get names and total spending for customers who have made a purchase in the...

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.

257
Nov 21