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: The query itself The number of rows And a small sample of data Display the names of our students that are male sorted in alphabetical order by last name and then first name. Display the names of our students that have a GPA of Display a list of students that have a GPA greater than Display the first and last name of students that are not male remember the gender field could be null Display the studentid of students that have an income greater than or equal to dollars sort it by the dollar amount highest to lowest Display the same information for students that have a combined income family and their own less than Also concatenate their first and last names and utilize an alias as Full Name and display the calculated column as Total Income How many students are from Massachusetts and have a GPA greater than How many students are from Massachusetts or have a GPA greater than How many students are from Massachusetts and have a GPA greater than or are female and from Alaska? How many students are from a New England state MA NH CT etc. How many students are from OH or WA or MA or WI AND have a GPA AND AND are male? List unique towns or cities in alphabetical order? Create queriesquestions 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 ConcatenationAlias 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
