Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Question 5 The query that displays the teachers who works at department starts with letter entered by user in ascending order: Not yet answered Marked
Question 5 The query that displays the teachers who works at department starts with letter entered by user in ascending order: Not yet answered Marked out of 1.00 a. select teacher_name from teachers where department_name like &letter%; O b. select teacher_name from teachers where department_name like &letter% order by upper(teacher_name); O c. select upper(teacher_name) from teachers where department_name like '&letter%' order by upper(teacher_name) desc; O d. select upper(teacher_name) from teachers where department_name like '8letter%' order by teacher_name: P Flag question Question 6 Display info about exams that have an average mark greater than or equal 40. Not yet answered Marked out of 1.00 a. SELECT exam_name,AVG(mark) FROM exam_results GROUP BY exam_name having avg(mark) >=40; O b. SELECT exam_name. AVG(mark) FROM exam_results GROUP BY exam_name where avg(mark) >40; OC. SELECT exam_name. AVG(mark) FROM exam_results having avg(mark)>=40; O d. SELECT exam_name,AVG(mark) FROM exam_results P Flag
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started