The COVID-19 pandemic, also known as the coronavirus pandemic, is an ongoing global pandemic of coronavirus disease 2019 (COVID-19) caused by severe acute respiratory syndrome coronavirus 2 (SARS-CoV-2). The novel virus was first identified from an outbreak in Wuhan, China, in December 2019. Attempts to contain it failed, allowing the virus to spread to other areas of Asia and later worldwide. The World Health Organization (WHO) declared the outbreak a public health emergency of international concern on 30 January 2020 and a pandemic on 11 March 2020. As of 27 October 2022, the pandemic had caused more than 629 million cases and 6.58 million confirmed deaths, making it one of the deadliest in history.
To gain insights into the Covid-19 pandemic, the following questions will be answered;
- What is the likelihood of dying from Covid in Denmark?
- What is the likelihood of contracting Covid in Denmark?
- What are the top 5 countries with the highest Covid infection rate in the world?
- What are the top 5 countries with the highest death count from Covid infection worldwide?
The data used for this exploration was acquired from https://ourworldindata.org on 8th October 2022.
SQL Operations in BigQuery
Q1: What is the likelihood of dying from Covid in Denmark?
There is 1.40% likelihood of dying from Covid-19 infection in Denmark.
Q2: What is the likelihood of contracting Covid in Denmark?
There is 16.58% likelihood of contracting Covid-19 infection in Denmark.
Q3: What are the top 5 countries with the highest Covid infection rate in the world?
Q4: What are the top 5 countries with the highest death count from Covid infection worldwide?