Given the following table(Please replace the spaces with underscore for the column names): Student Student ID...

 

Transcribed Image Text:

Given the following table(Please replace the spaces with underscore for the column names): Student Student ID 2125600 2125620 2125631 2125642 2125633 2125624 2125627 2125677 2125648 2125611 2125610 2125688 Title Miss Miss Mrs Mr Mr Miss Miss Mrs Mr Mr Miss Mr Last Name Adu Agbeko- Afrifa Arthur Ofori Aidoo Akafia Okoe Ampofo Poku Opoku Danso First Name Christiana Mavis Yvette John Amanfo Patience Lawrencia Theodora David Kwame Berlinda NULL Other Name NULL NULL Akosua Kingsley Emmaneul NULL NULL NULL NULL Nana Prosper Gender Female Female Female Male Male Female Female Female Male Male Female Male DOB 6/30/1981 NULL 10/25/1987 3/14/1993 1/12/1991 5/15/1978 6/4/1980 7/14/1984 NULL 11/13/1984 9/23/1991 12/10/1982 1. Create a stored procedure that will retrieve all student ids and first name if the first name is not null the from the table 2. Create a stored procedure that will retrieve all female students only 3. Create a table called students marks with student_id and random student marks (A, A-, B, C....) 4. Create a stored procedure that creates a view of the left outer joins of the two tables. Submit your query scripts in a word document format. POB Tema Kumasi Accra Mankesim Sefwi Winso Tarkwa Acera Sandema Navrongo Tamale Wenchi Koforidua Given the following table(Please replace the spaces with underscore for the column names): Student Student ID 2125600 2125620 2125631 2125642 2125633 2125624 2125627 2125677 2125648 2125611 2125610 2125688 Title Miss Miss Mrs Mr Mr Miss Miss Mrs Mr Mr Miss Mr Last Name Adu Agbeko- Afrifa Arthur Ofori Aidoo Akafia Okoe Ampofo Poku Opoku Danso First Name Christiana Mavis Yvette John Amanfo Patience Lawrencia Theodora David Kwame Berlinda NULL Other Name NULL NULL Akosua Kingsley Emmaneul NULL NULL NULL NULL Nana Prosper Gender Female Female Female Male Male Female Female Female Male Male Female Male DOB 6/30/1981 NULL 10/25/1987 3/14/1993 1/12/1991 5/15/1978 6/4/1980 7/14/1984 NULL 11/13/1984 9/23/1991 12/10/1982 1. Create a stored procedure that will retrieve all student ids and first name if the first name is not null the from the table 2. Create a stored procedure that will retrieve all female students only 3. Create a table called students marks with student_id and random student marks (A, A-, B, C....) 4. Create a stored procedure that creates a view of the left outer joins of the two tables. Submit your query scripts in a word document format. POB Tema Kumasi Accra Mankesim Sefwi Winso Tarkwa Acera Sandema Navrongo Tamale Wenchi Koforidua

Answer rating: 100% (QA)

1 Stored procedure to retrieve student ids and first names where first name is not null SQL CREATE PROCEDURE getstudentidsandfirstnames BEGIN SELECT Student ID First Name FROM yourtablename WHERE Firs... View the full answer