Computer scienceFundamentalsSQL and DatabasesBasics SQLRetrieving Data

SELECT FROM statement

Windy

Report a typo

A table is defined by the following statement:

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

Write a query that selects all the data related to the wind and corresponding hour. Columns in your query must go in alphabetical order.

Write an SQL statement





___

Create a free account to access the full topic