Can anyone help me in sql ?

Question

I need to build table for data base

> DATABASE
> SQL
1. The following is a database schema
// i cant show snap but its like tree structure

a. Write appropriate fields, create tables and show relations wherever necessary.
b. Write queries
i. Show special offers of December 2016,
ii. Show special offer for Black Friday and Christmas
iii. Show Easter special discounts only in Latest products
iiii. Show sold products not later than January 2017 from January 2016
v. Show product of initial quantity 500 and haven’t sold anything yet
vi. Create Sales table with appropriate fields.
vii. Get maximum sales in month for year 2015 and 2016
viii. Get the least sold product in the month December 2015.
ix. Show products that mostly on Christmas

2. Given is another database schema
// i cant show snap but its like tree structure

a. Write appropriate fields, create table structure and show relations using only headers.
b. Write queries
i. Get transactions of December 2016 made on Christmas eve.
ii. Show withstanding transactions
iii. Show category for each product
iiii. Show shipping address of each order placed before December 2016
v. Show common products sold in December 2016
vi. Show least purchased product in city ‘Chicago’
vii. Show most sold product in city ‘california’
viii. Show most purchased product in ‘Chicago’ and ‘California’
ix. Show common purchases in two Cities.
x. Show purchases which are order In ‘California’ and shipped to ‘Los Angeles’
Page 2

Answer 1

why tag java?

Answer 2

I saw your profile knowing you still not take Solo learn Mysql course yet. Advise you to complete the course. It's a short course.

https://www.sololearn.com/Course/SQL/?ref=app