question

Berta222 avatar image
Berta222 asked

SQL Query

Examine the following SQL query, and explain clearly and succinctly what it means. Will the query work? Explain why or why not.
WITH processed_users AS (SELECT LEFT(u.phone_country, 2) AS short_phone_country, SELECT FROM WHERE GROUP ORDER u.id FROM users u) t.user_id, t.merchant_country, Sum( t.amount / fx.rate / Power( 10, cd.exponent)) AS amount transactions t JOIN fx_rates fx ON ( fx.ccy = t.currency AND fx.base_ccy = 'EUR' ) JOIN currency_details cd ON cd.currency = t.currency JOIN processed_users pu ON pu.id = t.user_id t.source = 'GAIA' AND pu.short_phone_country = t.merchant_country BY t.user_id, t.merchant_country BY amount DESC

2. Find 5 likely fraudsters (not already found in fraudsters.csv!), provide their user_ids, and explain how you found them and why they are likely fraudsters.

sql querytransaction
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
greff379 avatar image
greff379 answered

Look at the manual sqls*plus - https://www.sqlsplus.com/. It should help you.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.