Question: can you write me general SQL queries for the questions below. You can use placeholders for the table, row and column names. Members who have

can you write me general SQL queries for the questions below. You can use placeholders for the table, row and column names.

  1. Members who have ordered polo shirt but have not received it

Member ID

Name (Last, first)

email

phone # (areacode-xxx-xxxx)

Shirt order date

Shirt order payment date

Shirt order payment amount

Shirt received? (show a N in resulting records)

  1. All current members
    1. Exclude the expired members
    2. Columns and format:

Member ID

Name (Last, first)

email

phone # (areacode-xxx-xxxx)

Latest payment date

Earliest payment date

Number of payments

Average payment amount

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:

can you write me general SQL queries for the questions below. You can use placeholders for the table, row and column names. Members who registered after 2017 Jan 1. Columns and format: Name (Last,...

Q:

can you write me general SQL queries for the questions below. You can use placeholders for the table, row and column names. Members who registered after 2017 Jan 1. Columns and format: Name (Last,...

Q:

Answer all 15 questions in SQL and make sure it runs correctly (e) The maximum load is measured in tons and never greater than test it on other servers you might get different behaviour. Don't forget...

Q:

You are to write, and run, SQL queries to answer a series of questions about a bank database. The database is an SQL Server DB on the Cypress server ( CYPRESS.csil.sfu.ca ) and you can access it in...

Q:

Questions 1 and 2 in this part relate to the ER model given below. The ER model illustrates the entities and relationships for modeling a stock research fine. Assume the firm has two types of staff ?...

Q:

SQL Query Design Module Preview This guide contains a preview of the materials for all module courses in this series: Using a Relational Database Management System Single Table Query Commands...

Q:

I do not understand what needs to be done, I've tried to watch the video with no luck. can you help, please? import into MysqL 2A. Under Server Administration on the Home window select the server...

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:

Porpoise acquires 100% of Sunfish in a taxable business combination. The applicable tax rate is 30%. Based on the following information about the assets and liabilities of Sunfish, what about should...

Q:

The following are audit procedures from different transactioncycles: 1. Examine sales invoices for evidence of internal verification ofprices, quantities, and extensions. 2. Select items from the...

Q:

diagnosis of part of the body - 3 that the hair come from can bedetected by which of the: followinga ) longitudinal section . b ) cross section.C - root examination.d ) nacked eye examination.

Q:

part c only, thanks Question 3 of 3 1.43/5 TIL Vaughn Fashion Center Trial Balance November 30, 2022 Debit Credit Cash 33,330 Accounts Receivable 37,120 Inventory 48,420 Supplies 8,920 Equipment...

Q:

3. Imagine that you are the Chief HR Officer for a company considering doing business in China. You have been informed that many of your competitors have implemented programs to hire the sons and...

Q:

2. Discuss whether targeting the children of wellconnected political or business leaders is ethical.

Q:

4. Higher-quality data on the performance of employees allows companies to better validate their selection process by connecting hiring decisions to outcomes.