This is my first post so I apologize if I am not concise enough. I am trying to come up with an SQL query to identify data quality issues.
Here's the sample table:
DeviceOS Bytes Roku 10,000 AppleTV -50000 SamsungTV -100000 Roku -100000 AppleTV 30000 Roku -90000 AppleTV -20000 AppleTV -10000 SamsungTV -100000
DeviceOS Total Count bad_count Roku 3 2 AppleTV 4 2 SamsungTV 1 1
Total_count field aggregates based on deviceOS and bad_count picks up only all the rows for which megabytes field is negative.
Essentially trying to do this-> select DeviceOS, count(*) from table group by DeviceOS
select DeviceOs, count(*) from table DeviceOS where megabytes < 0
How can I combine the above two queries and have the result of both of them displayed together similar to the output table?