Question: When I enter my SQL commands (below) it returns the columns I selected with no data. The problem I'm trying to solve with the table

When I enter my SQL commands (below) it returns the columns I selected with no data. The problem I'm trying to solve with the table are below the SQL commands.

SELECT FIRST_NAME, LAST_NAME, HIRE_DATE FROM GUIDE WHERE HIRE_DATE < 6/10/2013;

  1. List the guides last name and guides first name for all guides that were hired before June 10, 2013. For the table below.

    GUIDE
    GUIDE_NUM LAST_NAME FIRST_NAME ADDRESS CITY STATE POSTAL_CODE PHONE_NUM HIRE_DATE
    AM01 Abrams Miles 54 Quest Ave. Williamsburg MA 01096 617-555-6032 6/3/2012
    BR01 Boyers Rita 140 Oakton Rd. Jaffrey NH 03452 603-555-2134 3/4/2012
    DH01 Devon Harley 25 Old Ranch Rd. Sunderland MA 01375 781-555-7767 1/8/2012
    GZ01 Gregory Zach 7 Moose Head Rd. Dummer NH 03588 603-555-8765 11/4/2012
    KS01 Kiley Susan 943 Oakton Rd. Jaffrey NH 03452 603-555-1230 4/8/2013
    KS02 Kelly Sam 9 Congaree Ave. Fraconia NH 03580 603-555-0003 6/10/2013
    MR01 Marston Ray 24 Shenandoah Rd. Springfield MA 01101 781-555-2323 9/14/2015
    RH01 Rowan Hal 12 Heather Rd. Mount Desert ME 04660 207-555-9009 6/2/2014
    SL01 Stevens Lori 15 Riverton Rd. Coventry VT 05825 802-555-3339 9/5/2014
    UG01 Unser Glory 342 Pineview St. Danbury CT 06810 203-555-8534 2/2/2015

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 Databases Questions!

Q:

Title: Project Four: Developing A Three - Tier Distributed Web - Based Application Points: 1 0 0 points ( bonus problem potentially adds 1 5 points see page 2 8 . ) Objectives: To incorporate many of...

Q:

Project SEE attatchment of mom and pop database In this assignment you will create the physical database from your design created in Project 2. Project 2 was a logical model of the Mom & Pop...

Q:

Mom and POP database: Project 2 Based on the business requirements provided, the ERD would include the following entities: -Customers -Videos/DVDs -Movie -Distributors -Transactions Assignment to be...

Q:

Project 3 In this assignment you will create the physical database from your design created in Project 2. Project 2 was a logical model of the Mom & Pop database. We need to transition the logical...

Q:

CHAPTER 3 1. Which of the following is a correct statement? a. You can restore the data deleted with the DROP COLUMN clause, but not the data deleted with the SET UNUSED clause. b. You cant create...

Q:

DATABASE MANEGMENT SYSTEMS Lab: Using SQL Developer (Individual Assignment) Objective: Creating/populating tables using SQL commands in SQL Developer Learning how to add referential integrity and...

Q:

P L U G - I N T3 Problem Solving Using Excel 2010 LEARN IN G OUT C O ME S 1. 2. 3. 4. 5. Describe how to create and sort a list using Excel. Explain why you would use conditional formatting using...

Q:

This practice lab provides you the opportunity to create tables, primary keys and foreign keys with the use of SQL commands. The lab will utilize the FLIX2YOU problem. (In Microsoft SQL studio) In...

Q:

*Lab 6 is there in case you don't know what "Lab 7" instructions are referring to when they say" Lab 6." Lab 7 is the one that needs to be done. Lab 7: Inserting and Updating Data OVERVIEW This lab...

Q:

The following are the queries that are to be written using the BaseBall database you created for the course. Each question is worth 5 points. Points will be taken off for incorrect formatting (dollar...

Q:

Use the following information about the cash flows of Ferron Company to prepare a complete statement of cash flows (direct method) for the year ended December 31, 2008. (Negative amount should be...

Q:

Darwin Company holds assets with a fair value of $120,000 and a book value of $90,000 and liabilities with a book value and fair value of $25,000. Required Compute the following amounts if Brad...

Q:

Under the Minnesota Public Benefit Corporation Act, the directors of a B Corporation generally are relieved from their fiduciary duty to maximize shareholder value.ourse True * False

Q:

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

Q:

14-18 Compare the two major types of planning and control tools.

Q:

15-1 What major factors are driving the internationalization of business?

Q:

14-16 What could have been done to mitigate the risks of these projects?