Write down a sql statement to display the major of students

Assignment Help Database Management System

Reference no: EM13469511

Query 1: Write a SQL statement to display Students' First and Last Name.

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

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

Query 4: 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.

Query 5: 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.

Query 6: 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.

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

Query 8: Write a SQL statement to display the First and Last Name of students who have a last name that starts with an S.

Query 9: Write a SQL statement to display the First and Last Name of students having an a in the second position in their first names.

Query 10: 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.

Student_ID	Last_Name	First_Name	Address	Zip	Major	Class
1	Smith	James	555 Ohio Road	88888	Business	5
2	Doe	Jane	32 3rd Ave	88888	Biology	10
3	Miller	Mark	511 Easy streer	88808	Math	5
4	Smith	Ty	54 Main Street	88808	Math

Reference no: EM13469511

Questions Cloud

Ftp client without using any library you must create a : ftp client without using any library. you should create a seperate a socket program and then use that instead of

Recognize two important classes of catalysts examine the : recognize two important classes of catalysts. examine the chemical reactions which take place when the biological

Design a program whcih will allow a user to input a list of : design a program that will allow a user to input a list of your family members along with their age and state where

What percentage of gold-198 sample remains after 135 days : gold-198 is a beta emitter with a half-life of 2.7 days. what percentage of a gold-198 sample remains after 13.5 days?

Write down a sql statement to display the major of students : query 1 write a sql statement to display students first and last name. query 2 write a sql statement to display the

Rcognize the given as elements or compounds a nh3 b n2 c : identify the following as elements or compounds a nh3 b n2 c co d co and e he. give the numbers of protons and

Consider a big network with many desktops laptops and : consider a large network with many desktops laptops and networked printers. what are the advantages and disadvantages

Find mass number of the iron atom that has 28 neutrons : what is the mass number of an iron atom that has 28 neutrons? calculate the number of neutrons ofnbsp239pu. write the

Find empirical formulas of compounds with the given : tinii fluoride is often added to toothpaste as an ingredient to prevent tooth decay. what mass of fluoride in grams is

User Account

All Pages