Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
TRANSACTIONS
SELECT ATTRACTION_TYPE, COUNT(*) AS PURCHASES, SCHEDULE, SUM(PRICE) AS TOTAL_SALES, AVG(PRICE) AS AVG_PRICE FROM TRANSACTIONS WHERE SCHEDULE = 'JANUARY' GROUP BY ATTRACTION_TYPE
run
|
edit
|
history
|
help
0
STACK
№3
Common Table Expression
dk
Lisber-SQL-Example(CASE)
group_concat in sql-server
Stored procedure
Ggg
Datos relacional BRYAN
sql server dynamic 12 month time series and pivot with month year column names