Find the error in the following query?SELECT cust_id, fed_idFROM customerWHERE cust_id = ’I’AND fed_id BETWEEN 5000-00-000 AND 9999-999-000;
In the following query, what does “person_id” stands for?CREATE TABLE person (person_ id SMALLINT UNSIGNED, fname VARCHAR(20), lname VARCHAR(20) , CONSTRAINT pk_person PRIMARY KEY (person_id));
What will be the output of the following query?SELECT emp_id, fname, lnameFROM employeeWHERE LEFT (fname, 1) =’F’ OR LEFT (lname, 1) =’F’;