Question: Students must use the MariaDB database provided in the MySQL dump file named ForAssig 0 3 - dump.sql . After importing the database, students
Students must use the MariaDB database provided in the MySQL dump file named "ForAssigdump.sql After importing the database, students must create queries SELECT commands that will answer the following questions: Q: List the last name and first name of all drivers who drove for a shortterm contract together with the client's name. Sort the results in ascending order of the driver's last name. Q: List the trip numbers, their origin, and destination together with the names of clients with longterm contracts. List only records of clients whose name begins with the letter C Sort the results per the client's name and trip number. Q: List the last name and first name of all drivers together with the number plates of the vehicles they have driven for longterm contracts. Sort the list in ascending order of the driver's last name. Avoid duplication of records. Q: List the last name and first name of all drivers together with the number plates of the vehicles they have driven for shortterm contracts. List only drivers whose basic salary is greater than Sort the list in ascending order of the driver's last name. Avoid duplication of records. Q: List the number plates of all
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
