Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A store manager would like to send out ONE coupon to each of the customers that go to their store. Think about what is needed

  1. A store manager would like to send out ONE coupon to each of the customers that go to their store. Think about what is needed to mail a letter to someone and produce a query with that information.
    • Select a database with address information
    • Write a SELECT, FROM, WHERE statement that will pull the data to mail the coupon
    • Explain why you chose the data you selected

2. Choose three employees at your discretion, who you think deserve employee of the month. Then use what you know about concatenation to produce a chart that looks like this, but with the employees you chose:

Super Star Employees

*** Jimmy ***

*** Erin ***

*** Alex ***

  • Select a database with names
  • Create a SELECT, FROM statement to celebrate the employees

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction to Management Science

Authors: Bernard W. Taylor

11th Edition

132751917, 978-0132751919

More Books

Students also viewed these Algorithms questions

Question

What Makes Machine Learning Projects Unique in HR

Answered: 1 week ago