Purchase Solution

SQL Query: Student Information

Not what you're looking for?

Ask Custom Question

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.

Attachments
Purchase this Solution

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 ...

Purchase this Solution


Free BrainMass Quizzes
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.

Word 2010: Table of Contents

Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.

Basic Networking Questions

This quiz consists of some basic networking questions.

Javscript Basics

Quiz on basics of javascript programming language.