Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.
SELECT fname || ' ' || lname) user, count(*) total_submitted, FROM table WHERE submitted = 'Y' and trunc(date) between date1 and date2 group by fname || ' ' || lname) order by fname || ' ' || lname)
SELECT first_name, last_name, ext, (SELECT count(*) FROM tbl WHERE whatever gets total1) AS total1, (SELECT count(*) FROM tbl WHERE whatever gets total2) AS total2, (SELECT count(*) FROM tbl WHERE whatever gets total3) AS total3, ....... FROM tbl_users WHERE dept = deptid AND date BETWEEN date1 AND date2 ORDER BY first_name GROUP BY blah blah blah
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
14 Experts available now in Live!