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 "ForAssig03-dump.sql". After importing the database, students must create queries (SELECT commands) that will answer the following questions: Q1: List the last name and first name of all drivers who drove for a short-term contract together with the client's name. Sort the results in ascending order of the driver's last name. Q2: List the trip numbers, their origin, and destination together with the names of clients with long-term contracts. List only records of clients whose name begins with the letter 'C'. Sort the results per the client's name and trip number. Q3: List the last name and first name of all drivers together with the number plates of the vehicles they have driven for long-term contracts. Sort the list in ascending order of the driver's last name. Avoid duplication of records. Q4: List the last name and first name of all drivers together with the number plates of the vehicles they have driven for short-term contracts. List only drivers whose basic salary is greater than 115000. Sort the list in ascending order of the driver's last name. Avoid duplication of records. Q5: List the number plates of all

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!