Exercises by difficulty

Español

No order


Difficulty B


T10.004- Amount of orders from users with delivery address.

T10.011- Dates of the order and amount of orders performed that date, without considering the line orders with prices greater that 1000 €.

T10.012- Dates of order (only date) and total price paid in those orders, ordered by this total price.

T10.013- Number of order and amount of line orders for each order, ordered descendant by this amount.

T10.017- Amount of articles without rrp.

T10.018- Amount of articles without rrp and Unlisted.

T10.019- Brand and amount of articles whose name indicates that they are lenses with focals of ""18-200 mm"" or ""28-200 mm"", ordered descendant by this amount.

T10.020- Code and name of provinces, and average and standard deviation of the amount of articles ordered in those provinces.

T10.022- Number of order, date, email, surnames and name of users, and IVA (21 %, included in the prices, rounded to 2 decimals) to be applied in this invoice derived from orders, ordered by date and email.

T10.023- Number of order, date, email, surnames and name of users, and taxable income (price - 21 % IVA) of each invoice derived from the orders, ordered by date and email. Calculated with a round of 2 decimals.

T10.024- Year, month and total of IVA (21 %, included in the prices) applied, ordered by year and month. Calculated with a round of 2 decimals.

T10.025- Year, month and total of taxable income (IVA 21 %, included in the prices) of their orders, ordered by year and month. Calculated with a round of 2 decimals.

T10.026- By each year and month, taxable income, IVA (21 %, included in the prices) applied and total price of all their orders, ordered by year and month.Calculated with a round of 2 decimals.


Difficulty C


T10.001- Email, name and surnames of users, and name of the province and locality where he/she lives, ordered descendant by the total in euros buyed in our store.

T10.002- Email, name and surnames of users, and name of the province and locality where he/she lives, only the 5 users with that have ordered more in total euros in our store.

T10.003- Email, name and surnames of users, and name of the province and locality where he/she lives, only the five users that have ordered less in total euros in our store.

T10.005- Provinces and amount of orders served in those provinces, for those provinces with an average total price (price*amount) of their line orders greater that 1500 €.

T10.006- Brands and amount of cameras with avalilability greater that 0 units, if this amount of cameras is less than 20.

T10.007- Codes of province and localites of users that have made more than 1 order. Without duplicates.

T10.008- Brands and average of the rrp of its articles, except from the packs, and only the brands with an amount of articles greater that 100, ordered descendant by average.

T10.009- Code of the article and brand of the TV's whose average unit price in orders is greater in a 10% of the rrp.

T10.010- Code of the article, brand and average price of the cameras that have been ordered in more that two line orders, ordered by brand and code of the article.

T10.014- Surnames of users if these surnames are repeated in users table.

T10.015- Surnames and names of users if these surnames and names together are repeated in users table.

T10.016- Name of locality and amount of provinces in which this locality can be found, in case of towns with 2 o more provinces.

T10.027- By each year and month, taxable income, IVA (21 %, included in the prices) applied and total price of all their orders, ordered by year and month. Only the months whose amount of orders is greater that 10. Calculated with a round of 2 decimals.

T10.028- By each year and month, taxable income, IVA (21 %, included in the prices) applied and total price of all their orders, ordered by year and month. Only the months whose amount of orders is greater that 10 and eliminating the orders of the province 33 . Calculated with a round of 2 decimals.

T10.029- Dates of order and amount of orders done in those dates, except from the orders that contains lines with prices less than 1000 €.