need help. I have the answers but when running query 8 and query 9 in MS access
ID: 3561378 • Letter: N
Question
need help. I have the answers but when running query 8 and query 9 in MS access it returns no data
Query7 Write a SQL statement to display the First and Last Name of students who have the Status greater than 1 and less than 10. Use the SQL command BETWEEN. Query8 Write a SQL statement to display the First and Last Name of students who have a last name that starts with an S. Query9 Write a SQL statement to display the First and Last Name of students having an a in the second position in their first names. Query10 Write a SQL expression to display the Status and a sum of the Status of each Status value as SumOfStatus. Group by Status and display the results in descending order of SumOfStatus.Explanation / Answer
Write a SQL statement to display the First and Last Name of students who have the Status greater than 1 and less than 10. Use the SQL command BETWEEN.
SELECT FIRST_NAME,LAST_NAME
FROM STUDENT
WHERE STATUS BETWEEN 1 AND 10;
Write a SQL statement to display the First and Last Name of students who have a last name that starts with an S.
SELECT FIRST_NAME,LAST_NAME
FROM STUDENT
WHERE LAST_NAME LIKE S%;
Write a SQL statement to display the First and Last Name of students having an a in the second position in their first names
SELECT FIRST_NAME,LAST_NAME
FROM STUDENT
WHERE FIRST_NAME LIKE _a%;
Write a SQL expression to display the Status and a sum of the Status of each Status value as SumOfStatus. Group by Status and display the results in descending order of SumOfStatus.
SELECT STATUS,SUM(STATUS) AS sumofstatus
FROM STUDENT
GROUP BY STATUS
OREDR BY DESC(sumofstatus);
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.