We will be running all these queries in MYSQL workbench. If you don't have this on your system watch the link below to install it.
Some results have been hidden because they may be inaccessible to you
Show inaccessible resultsSome results have been hidden because they may be inaccessible to you
Show inaccessible results