Create queries that utilize the sql capabilities

Assignment Help Database Management System

Reference no: EM133055182

Learning Activity: Simple SELECT mi602_people database

Install the mi602_people database

MIS602_Module 3.1_mi602_people_database.sql

Work through the examples that are presented in the "Ask for Data from a Database" videos listed in the essential resources section to reinforce you learning:

Simpson, S. (2017, August 15). Learning SQL Programming [Video File].

In addition, create queries that utilize the following SQL capabilities

Filtering using
a list of values (SQL: IN)
date fields
comparison operators less than, greater than etc (SQL: <, >, <=, >=, <>, !=)
NULL and NOT NULL
BETWEEN
perform a mathematical calculation
field concatenation (SQL: concat)
Changing columns headings ie column alias

Create combinations of the above. E.g. find the state of people named ‘Gerald' who were born between 13th August 1989 and 1st Feb 1990 who don't belong to a company and have a blue shirt. Challenge the person next to you with the same information requests and see if they come up with the same queries.

Reference no: EM133055182

Questions Cloud

Productivity software options : Which productivity software options do you advise her to choose?

What is the opportunity cost in dollar value to the church : If the Church operates the homeless shelter, it receives a cash grant of $1,500 from the city. What is the opportunity cost in dollar value to the church

What is the differential revenue for leasing the truck : The truck originally cost $60,000 and has accumulated depreciation of $40,000. What is the differential revenue for leasing the truck

Technological innovations for security : What are the positive and negative implications of technological innovations for security and loss prevention programs?

Create queries that utilize the sql capabilities : Create queries that utilize the SQL capabilities and Create combinations of the above. E.g. find the state of people named ‘Gerald' who were born

Scrum systems development process : If a Scrum systems development process were used instead a traditional waterfall approach, what role would Stacy Thomas hire for first?

What is the purpose of administering vasoconstrictors : What is the purpose of administering vasoconstrictors to a client with shock?

Address customers-allergies-intolerances or sensitivities : What are the legal consequences of failing to address customers' allergies, intolerances or sensitivities?

Prepare the journal entries required of a government : The hospital received a $4,500 gift to be used for the purchase of specialized diagnostic equipment. Prepare the journal entries required of a government

User Account

All Pages