Analysis of Yearly Tax Revenue (% of GDP) in South Asian Countries Assignment

Assignment Task

Advanced SQL Final Test

1. WDI_DATA (the password is WDI) For each of South Asia countries (please, take a look at the REGION column in the WDI_COUNTRY table), please calculate: minimum and maximum yearly tax revenue (% of GDP) between 2005 and 2015. Show the values rounded to the first decimal place. In addition, please show the number of years for which data about tax revenue is available for each county. Please, use the WDI_INDICATOR_LIST table to find the proper code for the tax revenue (% of GDP), and then the WDI INDICATOR_VALUES table and the WDI_COUNTRY table (joined on COUNTRYCODE) to perform the calculations. You should get the following result set:

2. Recipes Example

Show a list of all ingredients (their ids and names) and a column which states whether a given ingredient is used in any recipe or not. Order the result set by INGREDIENTID. Your result set (with 79 records in total) should be constituted (among others) by the following records:

3. Sales Orders Example

Find a full name of a customer who in 2013 ordered products delivered by exactly 8 vendors. Please, use the HAVING keyword. You should get the following name in your result set: Caleb Viescas.

4. Entertainment Agency Example

Classify all engagements into 3 groups: engagements taking place on 1 day (i.e., their start date equals their end date), engagements taking place on 2 days, longer engagements. Then, for each group of engagements, show the number of engagements belonging to each group, and the number of customers who booked engagements from each group. You should get the following result set:

This Financial Analysis has been solved by our PhD Experts at My Uni Paper.