RPA Fraud Detection

test.sql

SELECT *
FROM transaction_data
LIMIT 10;

--2

SELECT full_name, email
FROM transaction_data
where zip = 20252;

--3

SELECT full_name, email
FROM transaction_data
where full_name = 'Art Vandelay' or full_name LIKE '%der';

--4 

SELECT ip_address, email
FROM transaction_data
where ip_address LIKE '10.%';

--5

SELECT email
FROM transaction_data
where email LIKE '%temp_email.com';

--6

SELECT *
FROM transaction_data
WHERE ip_address LIKE '120.%' and full_name LIKE 'John%';