Skip to content
/ Covid_19_Case_Study Public

Analysed some question on two different dataset one was day_wise.csv and second one was country_wise.csv

0 stars 0 forks Branches Tags Activity
Star
Notifications You must be signed in to change notification settings

Dhavaltharkar/Covid_19_Case_Study

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

10 Commits
Markdown
Markdown
 
 
.gitattributes
.gitattributes
 
 
README.md
README.md
 
 
covid_country_wise.sql
covid_country_wise.sql
 
 
covid_day_wise.sql
covid_day_wise.sql
 
 

Repository files navigation

Output related to Country_wise csv

Q1. Which country has the highest number of confirmed cases?

Q2. Identify the country with highest overall deaths total?

Q3. Find the country with lowest nymber of active cases?

Q4. Identidy the countrywise with highest totsl number of new deaths?

Q5. Region wise Confirmed Cases, Deaths, Recovery of a patient, and Active Cases?

Output related to day_wise csv

Q1. What is the total number of confirmed cases?

Q2. How many deaths has been reported so far?

Q3. What is the overall count of confirmed cases along with old and new cases total?

Q4. What is the totla number of active cases?

Q5. What is the total recovered patient for each month in the year 2020 from day_wise data?

Q6. What is the recovery of the patient day wise in the month of July for 2020 year from day_wise dataset?

Q7. Retrieve the monthly total deaths, along wth display month over month deaths and the difference between previous and current months?

About

Analysed some question on two different dataset one was day_wise.csv and second one was country_wise.csv

Topics

mysql sql workbench

Resources

Readme
Activity

Stars

0 stars

Watchers

1 watching

Forks

0 forks
Report repository

Releases

No releases published

Packages

No packages published

Languages