Question: To complete your work, please include: 1 . The query itself 2 . The number of rows 3 . And a small sample of data

To complete your work, please include: 1. The query itself 2. The number of rows 3. And a small sample of data 1. Display the names of our students that are male sorted in alphabetical order by last name and then first name. 2. Display the names of our students that have a GPA of 3.0.3. Display a list of students that have a GPA greater than 2.5.4. Display the first and last name of students that are not male (remember the gender field could be null).5. Display the studentid of students that have an income greater than or equal to 1750 dollars (sort it by the dollar amount highest to lowest).6. Display the same information for students that have a combined income (family and their own) less than 100,000. Also concatenate their first and last names and utilize an alias as Full Name and display the calculated column as Total Income.7. How many students are from Massachusetts and have a GPA greater than 3.0?8. How many students are from Massachusetts or have a GPA greater than 3.0?9. How many students are from Massachusetts and have a GPA greater than 3.0 or are female and from Alaska? 10. How many students are from a New England state (MA, NH, CT, etc.)?11. How many students are from OH or WA or MA or WI AND have a GPA >=2.5 AND <=3.5 AND are male? 12. List unique towns or cities in alphabetical order? 13. Create 3 queries/questions of your own that utilize any three of the following : a. Calculated Field b. Compound Criteria c. Null d. Sorting e. Distinct (unique values) f. Concatenation/Alias Note: You may use either students or movies for these questions. Please write the question, the query (SQL), and a sample of the results.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!