Welcome to SQL Queries Interview Questions for freshers. Below there are 10 questions that related to writting SQL Queries. You can either attemp to answer the questions or write the queries using for instance Microsoft AdvantureWorks samples database.
1. Show average spend by customer and average number of orders by customer.
2. Show 2011 total sales amount by region.
3. Return top 10 customers (total sales amount in 2011).
4. Show customers that own more than 1 car and spent in 2011 more than £2,000.
5. Show customers that haven't placed an order in the last 12 months.
6. Return customers that are more than 18 years old from today.
7. Show total number of unique products sold in 2011.
8. Return bottom 10 customer which spend at least £2,000 in 2011.
9. Show customer with the most recent order on the system.
10. Show customers that:
- Were born before 1983 and live in UK
- Own more than 2 cars