Purchase Solution

SQL Query Statements

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

This solution contains the queries written in a very easy to understand manner with proper formatting (required capitalization of words etc). The attached word document contains the tabulated queries with one column containing the problem and other column contains the query.

Solution Preview

Dear student,

Please find attached the solution.

Thanks, ...

Purchase this Solution
Free BrainMass Quizzes
C# variables and classes

This quiz contains questions about C# classes and variables.

Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.

C++ Operators

This quiz tests a student's knowledge about C++ operators.

Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.

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.

View More Free Quizzes
Related BrainMass Solutions

  • SQL Statements To Run In SQl Server

    94940 SQL Statements To Run In SQl Server Write SQL queries using Between, Like and Union: ? Write a SQL query that joins two tables in the example database and uses BETWEEN to restrict record selection.

  • Writing SQL Queries Using a Database and Tables

    249588 Writing SQL Queries Using a Database and Tables Write SQL queries (SELECT statements) using BETWEEN, LIKE, UNION, and GROUP.

  • SQL Statement

    This solution consists of questions on SQL queries mainly DML statements and select statement.

  • SQL Server Database for Kudler Fine Foods/Service

    The solution includes SQL query statements for tables creation, insertion, join, and union, also including group by and aggregation functions. Attached as a 7-paged Word document along with a .sql file.

  • Write SQL queries using BETWEEN, LIKE and UNION

    Using the updated database, write the following queries using the SQL GROUP BY statement and appropriate aggregate statements (when needed): Write a SQL query that displays the average salary / hourly wage grouped by job_title.

  • Methods that can be used to graphically create SQL queries

    All types of SQL statements can be parsed and run in the Query Builder dialog box. " In my opinion, as a professional SQL developer with ten years' experience, written code presents the most flexibility.

  • Structured Query Language (SQL) Preliminaries

    83369 Structured Query Language (SQL) Preliminaries 1. Discuss what SQL is and its importance. 2. Name and describe the SQL statements used for data modification. 3. Compare the join and the SQL subquery. 4.

  • SQL statements and query

    212168 SQL statements and query (3.7) Write a SQL query that uses UNION of the two tables. Be creative.

  • Summarizing query and explaining functions and grouping

    Basic SQL clauses and keywords used to aggregate and present data are in the list below: Clause Purpose Example SELECT Used to specify what fields will be included in the query result. This clause is always found in SQL query statements.

  • Structured Query Language Skills

    Step 7: Write the SQL statements Step 8: Verify that the query works Questions and answers: 1. From where should they source the information for the design?

View More Related Solutions