Advertisement
AmidamaruZXC

Untitled

Dec 13th, 2020
397
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.12 KB | None | 0 0
  1. SELECT SUM
  2. (
  3. CASE
  4. WHEN weight IS NULL
  5. OR calories IS NULL
  6. THEN 1
  7. ELSE 0
  8. END
  9. ) * 100 / COUNT(*)
  10. FROM Food;
  11.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement