Question

The cost of the seminars will be increasing by 20%. Write a query to calculate the new cost of the respective seminar. List the Seminar name, the current cost, and the new cost—name the field New Cost. (In that order) Use the properties window to display the new cost field as currency.

Answer 1

To calculate the new cost of a seminar after a 20% increase, multiply the current cost by 1.20. An example SQL query to determine this would be SELECT SeminarName, CurrentCost, FORMAT(CurrentCost × 1.20, 'C') AS 'New Cost' FROM Seminars; with 'FORMAT' used to show the new cost as currency.

Step-by-step explanation:

To calculate the new cost of the seminars after a 20% increase, you would take the current cost of the seminar and multiply it by 1.20 (or add 20% of the current cost to the current cost itself). The formula to find the new cost would be: New Cost = Current Cost × 1.20.Assuming we have a seminar named 'Learning SQL' with a current cost of $100, the calculation for the new cost would be: $100 × 1.20 = $120. Hence, the seminar 'Learning SQL' would have a new cost of $120 after the 20% increase.Here's a simple SQL query example to calculate the new costs:SELECT SeminarName, CurrentCost, FORMAT(CurrentCost × 1.20, 'C') AS 'New Cost'
FROM Seminars;In this query, 'FORMAT' function is used to display the new cost as currency. 'SeminarName' and 'CurrentCost' are column names which should be adjusted based on the actual column names in the database