User Account

All Pages

Count how many employees have blue eyes and are married.

Assignment Help Database Management System
Reference no: EM13949661

Using the attached database WK5_DB_ACCESS2000.mdb write SQL queries to answer the following questions.

1. Show the employee (by name) that is shortest.

2. Determine the average number of years that the average employee has been working.

Hint: here's how to get started:

SELECT (Now()-[HIRE_DATE])/365 AS YEARS
FROM EMPLOYEES;

3. Count how many employees have blue eyes and are married.

4. Write the SQL to answer this question: which employees have the same letter starting their first name as their last name (every employee actually meets this criteria, but pretend you didn't know that and write the SQL to figure this out.)

Hint: the Left() function will be helpful. For example: SELECT Left([L_NAME],1)

5. Answer this question using SQL: show which eye color is most dominant in the employees (its Brown, with a count of 4 employees) - in other words, show the eye colors by count but only show the max value of count (4).

Attachment:- WK5_DB_ACCESS2000.zip

Reference no: EM13949661

Questions Cloud

Evaluating the quality of a two-phase liquid-vapor mixture : 1. Each of the following exercises requires evaluating the quality of a two-phase liquid-vapor mixture: (a) The quality of a two-phase liquid-vapor mixture of H2O at 40°C with a specific volume of 10 m3/kg is
Investigating possible vulnerabilities of microsoft iis : Case Project: Investigating Possible Vulnerabilities of Microsoft IIS 6.0, Carrell Jackson, the Web developer for Alexander Rocco Corporation, has informed you that Microsoft 115 6.0 is used for the company's Web site
Prepare a table that shows total cost of forming equipment : Prepare a table that shows the total cost of forming equipment rental and unit cost for units ranging from 0 to 50,000, using increments of 10,000 units.
Brief discussion of the extent to which the provided data : A brief discussion of the extent to which the provided data and/or your chosen method of analysis are appropriate and/or sufficient to test the biological hypothesis.
Count how many employees have blue eyes and are married. : Write the SQL to answer this question: which employees have the same letter starting their first name as their last name (every employee actually meets this criteria, but pretend you didn't know that and write the SQL to figure this out.)
Determine the specific volume at the state : 1. Complete the following exercises. In each case locate the state on sketches of theT-y and p-y diagrams.
Write two equations for the mesh currents : Write two equations for the mesh currents shown in standard form. find the values of i1 and i2 find the voltage V (over the 2 Ohms resistor) and the current i (over the 3 Ohms resistor)
Determine specified property at the indicated state : 1. For each case, determine the specified property at the indicated state. Locate the state on a sketch of the T-y diagram.
Critically discuss the variety of personality measures : Identify and critically discuss the variety of personality measures available to managers. Your response should consider the purpose of this testing from an organisational perspective.

Reviews

Write a Review

Database Management System Questions & Answers

  Prepare a program so that it connects to a mysql database -

task 1you must setup your program so that it connects to a mysql database named gradingdb running on localhost. the

  Number of filenames as command-line arguments

Write the script called checking that will take any number of filenames as command-line arguments and will print the names of those files that are readable and writeable text files.

  An entity-relationship diagram for a database

an Entity-Relationship diagram for a database

  Project on data management

Premiere Products is a distributor of appliances, house wares, and sporting goods. Since its inception, the company has used spreadsheet software to maintain customer, order, inventory, and sales representative data. Redundancy and difficulty in..

  Part ause the prime minister database primeminister2013sql

part ause the prime minister database primeminister2013.sql available from the interact site. answer the following

  Sketch diagram for data warehouse of shop by star schema

Assume that data warehouse for video game shop consists of th three dimensions: time, player, and game, and two measures number of games played and price paid per game. Sketch schema diagram for data warehouse using the star schema.

  Explain why the addition of not null constraints to the sql

Explain why the addition of NOT NULL constraints to the SQL definition of the Manages relation would not enforce the constraint that each department must have a manager.

  How complicated are my data management tasks

To keep specific rows and columns from scrolling off the screen you first must position the cell pointer

  1 not having an appropriate index can cause a full table

1. not having an appropriate index can cause a full table scan while performing the select statement by using a

  Create a database.

Create a database.

  Describe database management systems

Describe Database Management Systems and the various models - Describe how organizations use databases to make decisions

  Create 3 rows of data for each table ensuring

Write SELECT statements for the following (include a screenshot of the SQL and its execution, including the resulting data).

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd