Question

the following question is based on the table information below.

Assume that the data is populated with records: CREATE TABLE teachers ( emp_id bigserial, first_name varchar(25), last_name varchar(50), school varchar(50), hire_date date, salary numeric); SELECT first_name, last_name, school, salary FROM teachers WHERE hiredate > '2008-01-01' ORDER BY last_name ASC;

Question 1) Will this query return an error?

Question 2) If there is an error, what is causing the error? if there is not an error, leave blank.

Answer 1

1) yes the above query will return error

Check below images for Explanation

For ur statemets this is output:

2) In SELECT statement "hiredate" was written as without underscore but in CREATE TABLE statement it wrriten as "hire_date".

after removing error output be like

if there is any concern please mention in comments.

thank you.

if u get the correct data please like