Computer scienceFundamentalsSQL and DatabasesBasics SQLRetrieving Data

SELECT FROM statement

Columns

Report a typo

A table is defined by the following statement:

CREATE TABLE Weather (
	day INTEGER,
	hour INTEGER,
	temperature INTEGER,
	feels_like INTEGER,
	wind_speed INTEGER,
	wind_direction VARCHAR(2),
	wind_gusts INTEGER,
	humidity DECIMAL(3,2),
	cloudiness DECIMAL(3,2),
	phenomena VARCHAR(50),
    pressure INTEGER
);

How many columns from the table "Weather" are referenced in the following query?

SELECT
    'Chicago' as place,
    day, 
    hour,
    phenomena,
    temperature*9/5+32 as "temperature in Fahrenheit",
    feels_like*9/5+32 as "feels like in Fahrenheit", 
    feels_like < temperature as "feels colder",
    wind_speed > 7 as "windy",
    humidity,
    cloudiness
FROM
    Weather
;
Select one option from the list
___

Create a free account to access the full topic