Purchase Solution

# SQL Query: Student Information

Not what you're looking for?

Query1 Write a SQL statement to display Students' First and Last Name.

Query2 Write a SQL statement to display the Major of students with no duplications. Do not display student names.

Query3 Write a SQL statement to display the First and Last Name of students who live in the Zip code 88888.

Query4 Write a SQL statement to display the First and Last Name of students who live in the Zip code 88888 and have the major of Biology.

Query5 Write a SQL statement to display the First and Last Name of students who live in the Zip code 88888 or 88808. Do not use IN.

Query6 Write a SQL statement to display the First and Last Name of students who have the major of Biology or Math. Use the SQL command IN.

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.

##### Solution Summary

The expert examines SQL Query for student information.

##### Solution Preview

1. Query1 Write a SQL statement to display Students' First and Last Name.
SELECT Student.First_name, Student.Last_name
FROM Student;

2. Query2 Write a SQL statement to display the Major of students with no duplications. Do not display student names.
SELECT DISTINCT MAJOR
FROM Student;

3. Query3 Write a SQL statement to display the First and Last Name of students who live in the Zip code 88888.

SELECT Student.First_name, Student.Last_name
FROM Student
WHERE ZIP ='88888'

4. Query4 Write a SQL statement to display the First and Last Name of ...

##### Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

##### C# variables and classes

This quiz contains questions about C# classes and variables.