1/ Write a PL/SQL function CALCULATE_TAX. This function should have two parameters: price and tax (tax is a percentage, for example, 8%). The function should return the tax amount for a given price and a given tax percentage. For example, CALCULATE_TAX(100.00, 5) returns 5.00.

2/ Write an SQL statement to list the total number of orders for each year for the female and male customers, and totals for each year (Hint: ROLLUP). Here is an example of the results:

YEAR GENDER NO OF ORDERS

1999 F 100

1999 M 50

1999 150

2000 F 80

2000 M 20

2000 100

LT -Star schema: LOCATION Location lD MALARIA FACTS o ID Age GroupID Period ID #total cases #-severe cases PERIOD Month Year Age GRQUP Group, Write an SQL query to list the total number of severe cases in Poland, Germany and Belarus in 2017 ? LT -Star schema: LOCATION Location lD MALARIA FACTS o ID Age GroupID Period ID #total cases #-severe cases PERIOD Month Year Age GRQUP Group, Write an SQL query to list the total number of severe cases in Poland, Germany and Belarus in 2017