Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ade161
Starting Member
1 Post |
 Posted - 2011-09-03 : 18:36:52
|
| I am new to sql and i need help answering the following questions:Q1. Write the SQL SELECT statement that returns the Name and 2000 population for cities in Tulsa County.Q2. Write the SQL SELECT statement that returns the Name of the cities where the population is greater than 250,000.Q4. Write the SQL SELECT statement that returns the Name of the cities where the feature is a populated place and the population is greater than 75,000.SELECT NAME FROM CITIES WHERE COUNTY=„Tulsa County? OR Oklahoma County?Q5. Why would you use OR rather than AND in the above example?Q6. Write the SQL SELECT statement that returns the name and 2000 population of Tulsa and Oklahoma City.Q7. Write the SQL Select statement that returns the cities that have a population greater than 100,000 but less than 200,000.Q8. Write the SQL Select statement that returns the cities that begin with the letter L.Q9. Using IN and NOT operators, write the SQL Select that returns the cities that are not located in Denton, Collin, or Lubbock Counties.SUM(POP2000)2247657Q10. Write a SQL statement that returns the sum of the population for in Oklahoma County.Q11. Write a SQL statement that returns the total population per county. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-03 : 23:58:53
|
| looks like homework questions. can we see what you tried till now? There's no use in we giving solutions for above questions as you wont be learning anything. so make a try and then post problems faced and we will help you out.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
SQL Help