Buenas tardes Alejandro, en el vídeo anterior se muestra el script utilizado para la tabla de ventas, la cual se creo sólo para el ejemplo. Te comparto el pequeño script e imagen.
CREATE TABLE sales ( Country VARCHAR(50), Region VARCHAR(50), Sales INT );
INSERT INTO sales VALUES (N'Canada', N'Alberta', 100); INSERT INTO sales VALUES (N'Canada', N'British Columbia', 200); INSERT INTO sales VALUES (N'Canada', N'British Columbia', 300); INSERT INTO sales VALUES (N'United State', N'Montana', 100);
SELECT Country, Region, SUM(sales) AS TotalSales FROM sales GROUP BY Country, Region;
Report
There was a problem reporting this post.
Block Member?
Please confirm you want to block this member.
You will no longer be able to:
See blocked member's posts
Mention this member in posts
Invite this member to groups
Message this member
Add this member as a connection
Please note:
This action will also remove this member from your connections and send a report to the site admin.
Please allow a few minutes for this process to complete.