Computer scienceFundamentalsSQL and DatabasesBasics SQLRetrieving Data

SELECT FROM statement

Weather

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 SELECT statement that lists the following values in the same order:

  • hour
  • the ratio of feels_like to temperature
  • pressure
Write an SQL statement





___

Create a free account to access the full topic