1. Table will log the websites traffic, table has website_name,page name,IP address, visited date columns. Write a query to get website visited in last 30 days,total number of visit for each website,total number of unique page view, total number of unique visitors (using IP address).
2. Employee table has Employee ID,Employee name,Joining Salary columns. Salary_hike table columns are Employee ID,Salary Hike percentage,Year .
Write a query to get total salary paid to employee during 2000 to 2015 year.