My SQL Challenge Question, Can You Solve it?
Posted by:
Eric Knight
Date: September 19, 2016 09:56PM
Hey Guys,
I'm working on problem hope someone can help and explain the right coding needed.
You have three MySQL tables with the following schema:
Table 1: “users”
id email client_id
1
joe@foobar.com 111
2
frank@testing.com 222
3
john@foobar.com 333
.
.
.
etc…
Table 2: “clients”
id name
111 Foobar Account #1
222 Foobar Display
.
.
etc...
id client_id impressions clicks conversions spend revenue
1 111 137498 3847 394 120048.38 82748.38
2 222 283729 3728 938 27382.38 83793.28
.
.
etc…
Write a single MySQL query that calculates the total impressions, clicks, conversions, spend, & revenue for all users whose email contains the domain “@foobar.com”.
Subject
Written By
Posted
My SQL Challenge Question, Can You Solve it?
September 19, 2016 09:56PM
September 20, 2016 05:28AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.