Ejercicios propuestos

Español

Classified by difficulty

T09.001- How many articles of each brand are there?

T09.004- Amount of cameras with sensor CMOS.

T09.012- There were an error in Tiendaonline and we introduce some articles without stock, with zero units available, in the basket. Obtain the code of those articles and how many times they appear in the basket.

T09.016- Amount of articles with stock 0

T09.017- Amount of articles that are not a memory, nor a tv, nor a lens nor a pack.

T09.021- Number of lines per order.

T09.022- Quantity of lines for each order, eliminating those rows with requested quantities of articles less than 3.

T09.023- For orders prior to September 2010, number of lines per order.

T09.024- For each item ordered, total number of units ordered.

T09.025- For each article ordered, total number of ordered units and average unit amount.

T09.026- For ordered cameras, article code, total number of units ordered and average unit amount.

T09.027- For the ordered cameras, code, name, brand of the article, and total number of ordered units and average unit amount.

T09.028- For all users whose first surname is Martínez, check if there is another user with the same last name and first name.

T09.029- For each month and year, number of orders placed.

T09.030- For articles 'A0233' and 'A1085', article code and number of different orders in which it has been requested.

T09.031- How many times have each article being ordered? If there are articles that have not been included in any order they will also appear in the output. Show the code and the name of the article together with the times it has been included in an order (only if it has been included, it is not the "amount").

T09.032- For each user, email and total retail price accumulated in their current baskets.

T09.033- For each user, email and total retail price accumulated in their current baskets, previously eliminating the items without PVP, and ordering from highest to lowest for that total.