Hello, I am working on a MySql lab code. There are 22 tasks on it. It is done on

Do you need this or any other assignment done for you from scratch?

We have qualified writers to help you.

We assure you a quality paper that is 100% free from plagiarism and AI.

You can choose either format of your choice ( Apa, Mla, Havard, Chicago, or any other)

NB: We do not resell your papers. Upon ordering, we do an original paper exclusively for you.

NB: All your data is kept safe from the public.

Click Here To Order Now!

Hello, I am working on a MySql lab code. There are 22 tasks on it. It is done on

Hello, I am working on a MySql lab code. There are 22 tasks on it. It is done on a website called GitHub. I will attach the link and how to access it once accepted. The instructions on what to do is also in the link I will send. Please make sure to read the instructions on the website in the companion. If possible, please provide a brief explanation as well. Below is an overview of what the tasks will be:
Task 1: List the item ID, description, and price for all items.
Task 2: List all rows and columns for the complete INVOICES table.
Task 3: List the first name, last name, and credit limit of customers with credit limits of $1,000 or more.
Task 4: List the invoice number for each order placed by customer number 125 on 2021-11-15.
If you need help, use the discussion of the DATE data type in Figure 3-16 in Module 3.
Task 5: List the customer ID, the first name, and the last name of each customer represented by sales rep 10 or sales rep 15.
Task 6: List the item ID and description of each item that is not in category HOR.
Task 7: List the item ID, description, and number of units on hand for each item that has between 10 and 30 units on hand, including both 10 and 30.
Task 8: List the item ID, description, and on-hand value (units on hand * unit price) of each item in category CAT. (On-hand value is technically units on hand * cost, but there is no COST column in the ITEM table). Assign the name ON_HAND_VALUE to the computed column.
Task 9: List the item ID, description, and on-hand value for each item where on-hand value is at least $1,500. Assign the name ON_HAND_VALUE to the computed column.
Task 10: Use the IN operator to list the item ID and description of each item in category FSH or BRD.
Task 11: Find the ID, first name, and last name of each customer whose first name begins with the letter S.
Task 12: List all details about all items. Order the output by description.
Task 13: List all details about all items. Order the output by item ID within location. (That is, order the output by location and then by item ID.)
Task 14: How many customers have balances that are more than their credit limits?
Task 15: Find the total of the balances for all customers represented by sales rep 10 with balances that are less than their credit limits
Task 16: List the item ID, description, and on-hand value of each item whose number of units on hand is more than the average number of units on hand for all items.
Use a sub-query.
Task 17: What is the price of the least expensive item in the database?
Task 18: What is the item ID, description, and price of the least expensive item in the database?
Use a sub-query.
Task 19: List the REP_ID and the corresponding sum of the balances, as BALANCE, of all customers for each sales rep. Order and group the results by sales rep ID.
Task 20: List the sum of the balances of all customers for each sales rep but restrict the output to those sales reps for which the sum is more than $150.
The results should display the REP_ID and BALANCE column headers. Order the results by sales REP_ID.
Task 21: List the item ID, description, and category of all items that are in the DOG or CAT category and contain the word Small in the description
Task 22: KimTay Pet Supplies is considering discounting the price of all items by 10 percent. List the item ID, description, price, and discounted price for all items. Use DISCOUNTED_PRICE as the name for the computed column.

Do you need this or any other assignment done for you from scratch?

We have qualified writers to help you.

We assure you a quality paper that is 100% free from plagiarism and AI.

You can choose either format of your choice ( Apa, Mla, Havard, Chicago, or any other)

NB: We do not resell your papers. Upon ordering, we do an original paper exclusively for you.

NB: All your data is kept safe from the public.

Click Here To Order Now!