SQL query or database script

SQL for MySQL, PostgreSQL, SQLite or SQL Server: reports, joins, cleanup or a table design. Send the table structure (no passwords); you get the tested queries and what each one does.