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

error: Content is protected !!