How to run nested/subquery in google sheet?

Question

SQl : select id,tod,count from new_temp where (id,count) in (select id,min(count) from new_temp group by id);

i want to run this in google sheet. How i can run this ?

[

Answer 1

try:

=SORTN(SORT(A2:C, 1, 1, 3, 1), 9^9, 2, 1, 1)

---

=SORTN(QUERY(A2:C7, 
 "select A,B,min(C) 
  where A is not null 
  group by A,B 
  order by A,min(C) 
  label min(C)''"), 9^9, 2, 1, 1)