MySQL Functions Quiz 3

Share with others

Welcome to your MySQL Functions Quiz 3

Name
Email
School Name
Q21. Write a query to calculate GST as 10% of Price from Inventory table and display the result after rounding it off to one decimal place.
Q22. Write a query to calculate sum of column Price from table Inventory.
Q23. Write a query to increase price of all products by Rs100 in table Inventory.
Q24. Write a query to add a new column Finaltax to the table inventory.
Q25. Write a query to calculate average of column "Finaltax" in table Inventory.
Q26. Write a query to display the car name(column name "carname") from table inventory who has maximum amount in "Finaltax" column.
Q27. Write a query to add a new column Commission to the Sale table. The column Commission should have a total length of 7 in which 2 decimal places to be there.
Q28. Write a query to display record from Sale table where Commission is more than 20000.
Q29. Write a query to display InvoiceNo, SalePrice and Commission from Sale table such that commission value is rounded off to 1 digit.
Q30. Write a query to display only first alphabet of carname in capital from sale table.


Share with others

Leave a Reply