Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2015

    Unanswered: Learning assignment: Trouble Writing Queries

    I am Using MYsql Console. New to databases.
    i Read chapters and pages for help but just can't seem to get it right.

    i created all my tables and insertions but i need to see how the queries are written.

    this is my code

    DB Code.txt

    These are the Queries:

    Write a query that selects all the jobs for a particular customer.

    Write a query that selects the jobs that David Garcia has worked on.

    Write a query that selects all the owner and addresses for bathroom installation jobs.

    Write a query that counts the number of jobs that need a kitchen sink.

    Write a query that selects the customer names and addresses for all the jobs that require fittings from Dennis Bathrooms.

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    Please post what you've done so far. We can't help you with queries without knowing how you have configured your tables, columns, and data.

    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Dec 2007
    Richmond, VA
    Provided Answers: 5
    As Pat said, we can't help you,due to lack of data and seeing what you are working with, but here are a couple examples to point you in the direction, put them to use on your tables and data.

    select jobs from job where customer = 'a particular customer'

    select jobs from job j
    inner join contractor c
    on j.job = c.job
    and c.contractor = 'David Garcia'

    etc... etc...

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts