I need to bring two fields from the same table, count the clients that comply with having a field with certain content and then divide them You could help me to do the following query in the correct way in the sqlite database engine.
Select (three / zero) as Value from (select
count (client_code)
FROM Farm_Report where F_alta="2018-02-01" and Difference = 3) as three,
(Select count (client_code) FROM Where_Report where
F_high="2018-02-01" and Difference = 0) as zero;