Which of the following WHERE clauses on a SELECT query on relation R(primaryKey, col) would be expected to have the lowest cost? Group of answer choices a. WHERE col BETWEEN 1 and 99 b. WHERE col IN (SELECT val FROM values) c. WHERE primaryKey = 4 d. WHERE col LIKE '%ae%'

Please convert this EERD to relation. Thanks

Hello, can you please assit me with this. I am struggling to get the code to run correctly without errors:   1.    Write a query using a join that displays         Department names (not Department_IDs)        Employees’ IDs, last & first names    Sort your results by department name and employee last and first name.        NOTE: INNER JOIN is OK here.    NOTE: I suggest you use table aliases.*/ /*2.    Write a query using a join that displays         Department names (no DEPARTMENT_IDs).         Job titles  (not Job_IDs)        Employees’ IDs, last & first names,     Sort your results by department name, job title, and employee last and first name.        NOTE: INNER JOIN is OK here.    NOTE: I suggest you use table aliases.*/ /*3.    Write a query using a self-join to display         Employees’ IDs and names along with         Their manager’s ID and name.     Use column aliases so that it is clear which columns are for the Manager and which columns are for the Employee.…