Sales Analysis – 1

Tables – product and sales are provided. Being area manager, you are looking for best seller by total sales price to reward and motivate them for best results. If there is a tie, all sellers would be qualified for same reward. Write SQL query to fetch all seller_id by total sale price. Input Table: sales … Read more

Sales Analysis – 2

Tables – product and sales are provided. product table holds data of all products and sales table represent sale transaction that was completed. Write SQL query to identify buyer_id who bought S10 but not iPhone. Input Table: sales seller_id product_id buyer_id sale_date quantity price 11 10 71 2019-02-22 3 6000 11 20 72 2019-03-27 1 600 … Read more

Tutor taking atleast 3 classes for a student

Tutor data is provided tutor_students table below. Table contains data of a month with tutor_id and student_id along with date of month on which tutor took class.Write a SQL query that provides the pairs (tutor_id, student_id) where the tutor has taken at least 3 classes for a student in single month.   Input Table: tutor_students … Read more

Gamers Analysis – 1

Write an SQL query and identify first login date for each gamer.   Input Table: gamers_activity player_id device_id event_date games_played 7 22 2017-04-02 4 7 22 2017-06-05 3 9 33 2018-02-26 0 6 11 2017-05-07 7 6 44 2019-08-06 3   Output Table: player_id first_login 7 2017-04-02 9 2017-04-02 6 2017-04-02 Explanation: “gamers_activity” table shows the activity … Read more

Gamers Analysis – 2

Write a SQL query that identify the device that was first used to log in for each gamer.   Input Table: gamers_activity player_id device_id event_date games_played 7 22 2017-04-02 4 7 22 2017-06-05 3 9 33 2018-02-26 0 6 11 2017-05-07 7 6 44 2019-08-06 3   Output Table: player_id device_id 7 22 9 33 … Read more