Columns with Sum of positive and negative values. | A table with single column is provided with integer values. Task is to create two … | 2019/07/15 | Easy | 2019-07-15 18:18:48 |
Sales Analysis – 3 | Tables – product and sales are provided. Write SQL query to identify products which were … | 2019/05/28 | Easy | 2019-05-28 19:10:50 |
SQL Contest – 14 days hackathon | Started on 1st July, 2019 – 2 weeks long hackathon was conducted, which concluded on … | 2019/03/17 | Hard | 2019-03-17 20:12:59 |
Post Views – 2 | Post views are being analysed using post_views table. This table contains information of all views … | 2018/12/14 | Medium | 2018-12-14 08:33:44 |
Post Views – 1 | Post views are being analysed using post_views table. This table contains information of all views … | 2018/12/14 | Easy | 2018-12-14 08:27:25 |
Product Sales Analysis – 3 | Write a SQL query that selects the product id, sale year, quantity, and price for the first year of … | 2018/08/27 | Medium | 2018-08-27 17:22:00 |
Product with sales increasing every year | A multinational Company is going through very bad timings and now want to focus on … | 2018/08/15 | Medium | 2018-08-15 11:50:35 |
Product Sales Analysis – 2 | Write an SQL query that reports the total quantity sold for every product id. … | 2018/07/12 | Easy | 2018-07-12 14:26:29 |
Product Sales Analysis – 1 | Write an SQL query that reports all product names of products in the “sales” table … | 2018/07/12 | Easy | 2018-07-12 14:07:43 |
Shortest distance in line on x-axis | Points of x coordinates are stored in table “points“. All entries of these points in … | 2018/06/09 | Medium | 2018-06-09 16:55:54 |
Sales Analysis – 1 | Tables – product and sales are provided. Being area manager, you are looking for best … | 2018/05/28 | Easy | 2018-05-28 18:35:29 |
Sales Analysis – 2 | Tables – product and sales are provided. product table holds data of all products and … | 2018/05/28 | Medium | 2018-05-28 05:20:03 |
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 … | 2018/04/08 | Easy | 2018-04-08 18:05:57 |
Gamers Analysis – 1 | Write an SQL query and identify first login date for each gamer. Input Table: gamers_activity player_id … | 2018/03/12 | Easy | 2018-03-12 15:19:25 |
Gamers Analysis – 2 | Write a SQL query that identify the device that was first used to log in … | 2018/03/01 | Easy | 2018-03-01 17:23:37 |