Which of the below select query will fail for this table?

You have created a table as below

CREATE TABLE SNOWFLAKE (FLAKE_ID INTEGER, UDEMY_COURSE VARCHAR);

Which of the below select query will fail for this table?
A . SELECT * from snowflake;
B. SELECT * from Snowflake;
C. SELECT * from "snowflake";
D. SELECT * FROM "SNOWFLAKE";

View Answer

Answer: C

Explanation:

Try it out yourself

On your demo instance, run the below queries

CREATE TABLE SNOWFLAKE (FLAKE_ID INTEGER, UDEMY_COURSE VARCHAR);

INSERT INTO SNOWFLAKE VALUES(1111, ‘SNOWFLAKE’);

SELECT * from snowflake;

SELECT * from Snowflake;

SELECT * from "snowflake";

SELECT * FROM "SNOWFLAKE";