SELECT * FROM blind_schema WHERE employer LIKE '%kpmg%' AND (industry = 'Management_Consulting' OR industry = 'tech' OR industry = 'software_engineering');
Might not return results, what if employer is case sensitive. Can you try again?
SELECT * FROM blind_schema WHERE UPPER(employer) LIKE '%KPMG%' AND (industry = 'Management_Consulting' OR industry = 'tech' OR industry = 'software_engineering');
I don't think sql injection works
Shucks, looks like I gotta find a different approach.
SQL outdated try nosql
Oh, the product manager I spoke to said it was a Postgres sql database over here oops
Try adding partition by (assuming this is for practice)
What do u mean? U want this broke up (partitioned) into multiple queries without the OR’s?
Just one query. With the “partition by” clause you can group rows by some column (just like group by) but instead of one aggregate result you can get a result per row. For example, how would you find the rank of each blind user based on age, per company? You can apply: row_number() over (partition by company order by age desc)
0 records found
Nah, I think the database is just big that it’s taking a bit of time to complete the query.
Nope. 0 records found
Can you do left join?
Yes. Ran ginormous sql queries at sunnova. Didn’t do many left joins, but there’s a time and place. You feel so powerful when you do them correctly lol