Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit89aee69

Browse files
committed
update
1 parentbe82f1a commit89aee69

File tree

1 file changed

+13
-9
lines changed

1 file changed

+13
-9
lines changed

‎1_SalesInsights/README.md‎

Lines changed: 13 additions & 9 deletions
Original file line numberDiff line numberDiff line change
@@ -11,36 +11,40 @@ https://www.youtube.com/watch?v=WuBcTJnIuzo
1111

1212
1. Show all customer records
1313

14-
`SELECT * FROMsales.customers;`
14+
`SELECT * FROM customers;`
1515

1616
1. Show total number of customers
1717

18-
`SELECT count(*) FROMsales.customers;`
18+
`SELECT count(*) FROM customers;`
1919

2020
1. Show transactions for Chennai market (market code for chennai is Mark001
2121

22-
`SELECT * FROMsales.transactions where market_code='Mark001';`
22+
`SELECT * FROM transactions where market_code='Mark001';`
2323

2424
1. Show distrinct product codes that were sold in chennai
2525

26-
`SELECT distinct product_code FROMsales.transactions where market_code='Mark001';`
26+
`SELECT distinct product_code FROM transactions where market_code='Mark001';`
2727

2828
1. Show transactions where currency is US dollars
2929

30-
`SELECT * fromsales.transactions where currency="USD"`
30+
`SELECT * from transactions where currency="USD"`
3131

3232
1. Show transactions in 2020 join by date table
3333

34-
`SELECTsales.transactions.*,sales.date.* FROMsales.transactions INNER JOINsales.date ONsales.transactions.order_date=sales.date.date wheresales.date.year=2020;`
34+
`SELECT transactions.*, date.* FROM transactions INNER JOIN date ON transactions.order_date=date.date where date.year=2020;`
3535

3636
1. Show total revenue in year 2020,
3737

38-
`SELECT SUM(sales.transactions.sales_amount) FROM sales.transactions INNER JOIN sales.date ON sales.transactions.order_date=sales.date.date where sales.date.year=2020;`
38+
`SELECT SUM(transactions.sales_amount) FROM transactions INNER JOIN date ON transactions.order_date=date.date where date.year=2020 and transactions.currency="INR\r" or transactions.currency="USD\r";`
39+
40+
1. Show total revenue in year 2020, January Month,
41+
42+
`SELECT SUM(transactions.sales_amount) FROM transactions INNER JOIN date ON transactions.order_date=date.date where date.year=2020 and and date.month_name="January" and (transactions.currency="INR\r" or transactions.currency="USD\r");`
3943

4044
1. Show total revenue in year 2020 in Chennai
4145

42-
`SELECT SUM(sales.transactions.sales_amount) FROMsales.transactions INNER JOINsales.date ONsales.transactions.order_date=sales.date.date wheresales.date.year=2020
43-
andsales.transactions.market_code="Mark001";`
46+
`SELECT SUM(transactions.sales_amount) FROM transactions INNER JOIN date ON transactions.order_date=date.date where date.year=2020
47+
and transactions.market_code="Mark001";`
4448

4549

4650
Data Analysis Using Power BI

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp