Comment by miquong

If you're following along and can't/don't want to remember the SQL syntax, use the examples from the post for LLM text-to-SQL context:

  Q: Which photo has the highest number of faces?
  A: SELECT SourceFile
  FROM photos
  WHERE RegionType IS NOT ''
  ORDER BY length(RegionType) DESC
  LIMIT 1;
  
  Q: ...

You can also fetch and use the table schema with `sqlite3 exif.db .schema`