Write a query to display the number of rows

Assignment Help Management Information Sys

Reference no: EM133127158

Assignment Details: Please use scripts below

Question 1: Using MySQL, create an ERD to show the tables and relationships of the sales_co schema.

Question 2. Write a query to display the number of rows in the line table.

Question 3. Write a query to show everything in the product table. Add a field called "Assets^TM to calculate quantity * price, order by this field from highest to lowest.

Question 4. Write a query to determine which product has the highest number of units sold.

Question 5. Using the product table, write a query to show the top 4 products that are closest to their reorder point.

Question 6. Using the product and vendor tables, write a query that shows the vendor along with information about the product they sell.

Question 7. Using the query from #6, change your query to find any products without a vendor.

Question 8. Using the customer and invoice tables, write a query to show the customer id, first name, last name, and number of purchases the customer made. Rename the last field ˜Orders^TM.

Question 9. Using the query from #8, add the line table and add the following fields to your query: number of invoice lines (renamed to OrderItems), total units sold (renamed to UnitsSold). Hint "Orders and OrderLines should be different numbers for some customers!

Bonus: 5 extra credit points if you display the correct value for units * price (renamed to SaleAmount^TM). Double-check your work by querying the data to confirm your results.

Attachment:- scripts.rar

Reference no: EM133127158

Questions Cloud

Record credit sales and the allowance for doubtful accounts : Assume that C&S had total credit sales (before allowances) of $1,400,000 in 2016. Record credit sales and the allowance for doubtful accounts

Explain the different levels of production : A firm has the following marginal costs at different levels of production. If it is able to sell al the products it can produce at $5 each, how many will it pro

Discuss the view that price floors are more effective : Discuss the view that price floors are more effective than subsidies in providing assistance to producers in the agricultural sector.

Currency exchange rate reflect that the euro currency : Does the below currency exchange rate reflect that the Euro currency has appreciated? Spot Rate One Year Ago?

Write a query to display the number of rows : Write a query to determine which product has the highest number of units sold and write a query to show the customer id, first name, last name, and number

Shaping public opinions about social issues : What role do social media play in shaping public opinions about social issues?

Virtuous leadership and servanthood : He then took personal responsibility, prayed, and asked God to forgive him and his people for not obeying his commands.

How can we internalize externalities using coase theorem : How can we internalize externalities using Coase Theorem? What are marketable permits and how do they qualify as performance-based regulation?

Calculate the net cost of inventory purchased : Calculate the net cost of inventory purchased assuming that there are no other inventory-related transactions during the month

User Account

All Pages