When you add online shopping to your website, it may not immediately integrate with your accounting or inventory systems. This means that until you can implement an automatic interface, you may need ...
When your SQL query is ready, you can run the query immediately or you can add a title, change its options, limit its output, and so on, to make the report look better. See Viewing the SQL Code, ...
Don't be afraid of using your chosen database's command-line client. I might as well say this up front: I don't like using GUI (aka non-command-line or graphical) tools with my databases. This is ...