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
Train Reservation
Sql Question 1
Primary key and unique key for single column and multi columns
ss sqlpractice2014
Library Datebase
Practice
Test
PIVOT AND UNPIVOT USING XML PARSING
program2
Q2_5MIN