Generate a report to display names of the countries in Europe, Africa or Asia, # where vaccine

Fantastic news! We've Found the answer you've been seeking!

Question:

Generate a report to display names of the countries in Europe, Africa or Asia,

# where vaccine is not available on April 1, 2021 and the name of the country starts with I

#*******************************************************************************

# Challenge level for this question is Medium. This is how you should try to attempt:

# (1) Try without looking at any hints by just looking at the question

# (2) Then look at just the syntax and try to answer

# (3) Then look at the steps and try filling in the missing values (as denoted by < and >) in the syntax

#*******************************************************************************

# Hints:

# Syntax: SELECT

# FROM

# WHERE AND AND AND

# Step 1: Columns: location (column alias: country)

# Step 2: Table name: covid

# Step 3: WHERE clause with four conditions separated by AND

# Step 4: Condition 1: continent IN Europe, Asia and Africa (you can also use OR, however, IN is concise)

# Step 5: Condition 2: you will use IS NULL on people_fully_vaccinated_per_hundred

# Step 6: Condition 3: pattern matching on location LIKE I%

# Step 7: Condition 4: DATE(date) = DATE('2021-04-01')

sqldf("

# write query here

") # (1 point)

What is the correct query?

Related Book For answer-question

ISBN: 9781285586618

31st Edition

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

See More Books

Posted Date: Sep 16, 2023 09:13 AM