Task 3 4 3 Points Who S Enrolled In Web And Database Computing O Write A Sql Query To List The Names Of All Student 1 (92.38 KiB) Viewed 42 times
Task 3.4 (3 points) . Who's enrolled in Web and Database Computing? o Write a SQL query to list the names of all students enrolled in Web and Database Computing. o The query should only list the names (given, family) of these students, no other information. Use a text editor to save the query in a text file named query3-4.sql o Save the query itself, not its output. . Don't forget the Semicolon ; at the end of the query. Task 3.5 (4 points) . • Who's struggling with Computer Systems? o Write a SQL query to list the names and scores of all students currently failing (score less than 50) Computer Systems. o The query should only list the names and scores of these students, no other information. • Save the query in a file named query3-5.sql Task 3.6 (4 points) • Bob Smith (a1111113) passed his Object Oriented Programming (COMP SCI 1102) Supp! o Write a SQL query to update Bob's score in Object Oriented Programming to 50. Save the query in a file named query3-6.sql .
Students student_id a1111111 given_name family_name Fang Li a1111112 Jane Brown program BE(Hons)(Soft) BE(Hons)(Soft) BCompSc BCompSc a1111113 Bob Smith a1111114 Wei Zhang Subjects subject_code subject faculty COMP SCI 1102 Object Oriented Programming ECMS COMP SCI 2207 Web and Database Computing ECMS COMP SCI 2000 Computer Systems ECMS PHIL 2039 Philosophy of Mind Arts Enrolments student_id subject_code mark a1111111 COMP SCI 1102 62 a1111111 COMP SCI 2000 80 a1111112 COMP SCI 1102 55 a1111112 COMP SCI 2207 80 a1111113 PHIL 2039 65 a1111113 COMP SCI 1102 46 a1111114 COMP SCI 2207 67 a1111114 COMP SCI 2000 49
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!