Mysql-new user guide SQL queries the basic information of each user, the latest logon log information and the latest version information.

Write an SQL statement to query the basic information of all users, the latest logon logs, and the latest version information. user table: user log table: log version table. The result is as follows: user name User ID recent logon time recent logon location latest version number Updated version Time User table idnamelog table iduser_idlogin_timelogin_siteversion table iduser_idversion_noupgrade_time mysql

Write an SQL statement to query the basic information of all users, the latest logon logs, and the latest version information. user table: user log table: log version table. The result is as follows: user name user ID recent logon time the latest version number of the last logon location updated time
User table
Id
Name
Log table
Id
User_id
Login_time
Login_site
Version table
Id
User_id
Version_no
Upgrade_time