Skip to content

Files

Latest commit

mrmightyqmrmightyq
Create SQL Exercises: Find the highest purchase amount of the custome…
May 2, 2022
fd44327 · May 2, 2022

History

History

w3resource

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
# 1
# 1
 
 
# 10
# 10
 
 
# 11
# 11
 
 
# 12
# 12
 
 
# 13
# 13
 
 
# 14
# 14
 
 
# 16
# 16
 
 
# 17
# 17
 
 
# 18
# 18
 
 
# 19
# 19
 
 
# 2
# 2
 
 
# 20
# 20
 
 
# 21
# 21
 
 
# 26
# 26
 
 
# 27
# 27
 
 
# 3
# 3
 
 
# 30
# 30
 
 
# 32
# 32
 
 
# 34
# 34
 
 
# 37
# 37
 
 
# 38
# 38
 
 
# 39
# 39
 
 
# 44
# 44
 
 
# 46
# 46
 
 
# 48
# 48
 
 
# 50
# 50
 
 
# 52
# 52
 
 
# 53
# 53
 
 
# 54
# 54
 
 
# 56
# 56
 
 
# 57
# 57
 
 
# 58
# 58
 
 
# 59
# 59
 
 
# 6
# 6
 
 
# 60
# 60
 
 
# 62
# 62
 
 
# 64
# 64
 
 
# 65
# 65
 
 
# 66
# 66
 
 
# 68
# 68
 
 
# 69
# 69
 
 
# 7
# 7
 
 
# 70
# 70
 
 
# 72
# 72
 
 
# 73
# 73
 
 
# 76
# 76
 
 
# 77
# 77
 
 
# 8
# 8
 
 
# 9
# 9
 
 
SQL Exercises: Display the average price of items of each company, showing the name of the company
SQL Exercises: Display the average price of items of each company, showing the name of the company
 
 
SQL Exercises: Display the first name and last name of each employee, along with the name and sanction amount for their department
SQL Exercises: Display the first name and last name of each employee, along with the name and sanction amount for their department
 
 
SQL Exercises: Display the names of the company whose products have an average price larger than or equal to Rs.350
SQL Exercises: Display the names of the company whose products have an average price larger than or equal to Rs.350
 
 
SQL Exercises: Find the highest purchase amount of the customers in a particular date
SQL Exercises: Find the highest purchase amount of the customers in a particular date
 
 
SQL Exercises: Find the names of departments where more than two employees are working
SQL Exercises: Find the names of departments where more than two employees are working
 
 
SQL Exercises: Find the salesmen and customers with their name and cities, who belongs to the same city
SQL Exercises: Find the salesmen and customers with their name and cities, who belongs to the same city
 
 
SQL Exercises: Make a list of customers who appointed a salesman for their jobs who does not live in the same city where their customer lives, and gets a commission is above 12%
SQL Exercises: Make a list of customers who appointed a salesman for their jobs who does not live in the same city where their customer lives, and gets a commission is above 12%
 
 
SQL Exercises: Make a list of customers who appointed a salesman for their jobs who gets a commission is above 12%
SQL Exercises: Make a list of customers who appointed a salesman for their jobs who gets a commission is above 12%
 
 
SQL Exercises: Prepare a list for which salesman are working for which customer along with city and commissions earned by the salesman
SQL Exercises: Prepare a list for which salesman are working for which customer along with city and commissions earned by the salesman
 
 
SQL Exercises: Prepare a list with order no, purchase amount, customer name and their cities for those orders which order amount between 500 and 2000
SQL Exercises: Prepare a list with order no, purchase amount, customer name and their cities for those orders which order amount between 500 and 2000