IDStudent NumberSurnameNameTest 1Test 2Test 3Test 4Final markPASS/FAIL1217545455JohanessWheeler45%34%49%21%37FAIL2217452154DavidAlbertina45%34%49%4%33FAIL3217454151WaldoGertze75%75%63%88%75PASS4217486414KalimboAndreas51%56%90%90%72PASS5217454155HakweendaJunior44%28%35%14%30FAILAnswer the following questions using the table above Use student 2017 table to create a query that will display Student Number, Surname, Name and Pass/Fail field for all the students whose final result is "PASS". Save the query as "Pass". Use student 2017 to create a query that will display the student's surname and final mark field for all the students whose final mark is between 0 - 40. Save the query as "Fail" Use student 2017 to create a query that will display the student number and surname for all the students whose surname consist of letter "O" in it. Save the query as "Surname".

Given Use student 2017 table to create a query that will display Student Number, Surname, Name and…

Answered: ID Student Number Surname Name Test 1…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

ID	Student Number	Surname	Name	Test 1	Test 2	Test 3	Test 4	Final mark	PASS/FAIL
1	217545455	Johaness	Wheeler	45%	34%	49%	21%	37	FAIL
2	217452154	David	Albertina	45%	34%	49%	4%	33	FAIL
3	217454151	Waldo	Gertze	75%	75%	63%	88%	75	PASS
4	217486414	Kalimbo	Andreas	51%	56%	90%	90%	72	PASS
5	217454155	Hakweenda	Junior	44%	28%	35%	14%	30	FAIL

Answer the following questions using the table above

Use student 2017 table to create a query that will display Student Number, Surname, Name and Pass/Fail field for all the students whose final result is "PASS". Save the query as "Pass".
Use student 2017 to create a query that will display the student's surname and final mark field for all the students whose final mark is between 0 - 40. Save the query as "Fail"
Use student 2017 to create a query that will display the student number and surname for all the students whose surname consist of letter "O" in it. Save the query as "Surname".

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions