Computer scienceFundamentalsSQL and DatabasesBasics SQLRetrieving Data

SELECT FROM statement

Impression

Report a typo

A table is defined by the following statement:

CREATE TABLE Impression (
    banner_id INTEGER,
    background_color VARCHAR(6),
    banner_width REAL,
    banner_height REAL,
    cost_per_click DECIMAL(3,3),
    is_click BOOLEAN
);

Choose the correct query for getting data from this table.

Select one option from the list

SELECT * FROM table;

SELECT banner_id, banner_width, banner_height FROM banner;

SELECT cost_per_click as "cost per click in US dollars";

SELECT banner_id, cost_per_click FROM Impression;

___

Create a free account to access the full topic