Write a query to summarize by memberid

Assignment Help Computer Engineering

Reference no: EM133627458

Query 1 Write a query to summarize by MemberID, the number of prospects for Lee Trevino or the number of prospects for Robert Johnson. List the MemberID, Member Last name, and their number of prospects.

Query 2 Write a query to summarize by MemberID, their average payment between May 9, 2017 and June 1, 2017. List the MemberID and their average payment.

Query 3 All members will receive a 10% discount on their total charges. Write a query to summarize by MemberID the Discounted charge (name the field Discounted Charge). List the MemberID, StatusID, member's first name, last name, the total charges and the discounted charge. Format the new Discounted Charge field to Currency.

Query 4 Write a query to display the number of members who live in Ohio. List only the number of members.

Reference no: EM133627458

Questions Cloud

Which would you feel is more effective : How are they similar? How are they different? Which would you feel is more effective if you were selecting which one to use in an organization?

What is a scope baseline and what are its components : What is a scope baseline, what are its components, and why is it important? Give an example of each class of constraint on determining the activity sequence.

Plan and design the network for one of the organizations : Plan and design the network for one of the organizations in the city. You are assigned to implement the wireless network for thecompany situated

What is the quickest way to use todays date : What is the quickest way to use todays date when you are creating a new row? Simply write today's date in the format 'dd-mon-rrrr'. Use the TODAYS_DATE

Write a query to summarize by memberid : Write a query to summarize by MemberID, the number of prospects for Lee Trevino or the number of prospects for Robert Johnson. List the MemberID, Member Last

What code statement can be used to assign values to the year : myRide.make = 'Yugo' myRide.model = 'GVX'; myRide.year = '1980'. What code statement can be used to assign values to the year property

Which network topology best support industrys business needs : Select an industry and recommend which network topology best supports this industry's business needs. Support your rationale with examples.

What is the running time of each method : Find the shortest path from node A (source node) to all other nodes using: a) BFS b) Dijkstra c) Bellman-Ford Compare these algorithms. Identify the different

Encompasses the creation and transmission : Encompasses the creation and transmission of warnings about a detected incident as well as the control over the reaction toward the warnings

User Account

All Pages