fbpx
/5

MySQl Practice Questions

MySQL also referred to an Structured Query Language. Use the Northwind Database for this quiz

1 / 5

1. Create a report that shows all the CustomerID in lowercase letter and renamed as ID from the customers table.

2 / 5

2. Create a report that shows the ContactName, CompanyName, ContactTitle and Phone number from the customers table sorted by Phone.

3 / 5

3. Create a report that shows the top 10 OrderID, OrderDate, ShippedDate, CustomerID,  Freight from the orders table sorted by Freight in descending order.

4 / 5

4. Create a report that shows the CategoryName and Description from the categories able sorted by CategoryName.

5 / 5

5. Create a report that shows the capitalized FirstName and capitalized  LastName renamed as FirstName and Lastname respectively and HireDate from the employees table sorted from the newest to the oldest employee.

Your score is

0%

/5

MySQl Practice Questions

MySQL also referred to an Structured Query Language. Use the Northwind Database for this quiz

1 / 5

1. Create a report that shows all the CustomerID in lowercase letter and renamed as ID from the customers table.

2 / 5

2. Create a report that shows the capitalized FirstName and capitalized  LastName renamed as FirstName and Lastname respectively and HireDate from the employees table sorted from the newest to the oldest employee.

3 / 5

3. Create a report that shows the ContactName, CompanyName, ContactTitle and Phone number from the customers table sorted by Phone.

4 / 5

4. Create a report that shows the CategoryName and Description from the categories able sorted by CategoryName.

5 / 5

5. Create a report that shows the top 10 OrderID, OrderDate, ShippedDate, CustomerID,  Freight from the orders table sorted by Freight in descending order.

Your score is

0%

Join our MySQL Training

Register for MySQL training. Online or Physical Classes available. Call/Whatsapp +2347055247562

Click Here
/5

MySQl Practice Questions

MySQL also referred to an Structured Query Language. Use the Northwind Database for this quiz

1 / 5

1. Create a report that shows the ContactName, CompanyName, ContactTitle and Phone number from the customers table sorted by Phone.

2 / 5

2. Create a report that shows all the CustomerID in lowercase letter and renamed as ID from the customers table.

3 / 5

3. Create a report that shows the CategoryName and Description from the categories able sorted by CategoryName.

4 / 5

4. Create a report that shows the capitalized FirstName and capitalized  LastName renamed as FirstName and Lastname respectively and HireDate from the employees table sorted from the newest to the oldest employee.

5 / 5

5. Create a report that shows the top 10 OrderID, OrderDate, ShippedDate, CustomerID,  Freight from the orders table sorted by Freight in descending order.

Your score is

0%

/5

MySQl Practice Questions

MySQL also referred to an Structured Query Language. Use the Northwind Database for this quiz

1 / 5

1. Create a report that shows the top 10 OrderID, OrderDate, ShippedDate, CustomerID,  Freight from the orders table sorted by Freight in descending order.

2 / 5

2. Create a report that shows the capitalized FirstName and capitalized  LastName renamed as FirstName and Lastname respectively and HireDate from the employees table sorted from the newest to the oldest employee.

3 / 5

3. Create a report that shows all the CustomerID in lowercase letter and renamed as ID from the customers table.

4 / 5

4. Create a report that shows the ContactName, CompanyName, ContactTitle and Phone number from the customers table sorted by Phone.

5 / 5

5. Create a report that shows the CategoryName and Description from the categories able sorted by CategoryName.

Your score is

0%

Need Help? Chat with us
Start a Conversation
Hi! Click to chat on WhatsApp
The team typically replies in a few minutes.
Customer Support
Customer Support