Solved by Expert Tutors
Solved by Expert Tutors
Question

create a C# code to print out qualified customers for promo code,

giving the SQL query below. Use Console.WriteLine to display the results. 
string sqlQuery = select CustomerID, count(issuetran.customerID) as Number_Of_Transactions from issuetran group by customerID having count(customerID) >= 10 order by Number_OF_Transactions


Sample Output Format (console screen):


Customer_ID Number of Transaction
2688       10
2820       10
2983       10
5489       10
6598       10
8788       10
5968       11
2270       11
4312       11
5108       11
2345       13
1003       13
8756       14
6542       14

Step-by-step answer

et, c

nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna.



facilisis. Pellentesque

usce dui lectus, congue vel

facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, da

amet, co

usce dui lectus, congue vel la

nec facilisis. Pellentesque dapib

sque dapibus efficitur l

dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce d

s ante, dapibus

ec facilisis. Pellentesque dapibus eff

m risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, co

ultrices ac magna. Fusce

ec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a

llentesque dapibus efficitur laoreet. Nam risus ante

ce dui lectus, congue vel laoreet a

ctum vitae odio. Donec aliquet. L

Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum

itur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui

pulvinar tortor nec facilisis. P

e vel laoreet ac, dictum

ec aliquet. Lorem

sum dolor

acinia pulvi
  • a. Fusce dui lectus, congue vel laoreet ac, dictum
  • risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, c
  • Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipi

Subscribe to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question