Complete the following exercise.

Write SQL that will return the date$-$time and server$\_$principal$\_$name for all successful logins$.$ From an audit perspective, why would you want to know when individuals$/$applications successfully log in$?$

Write SQL that will return the date$-$time and server$\_$principal$\_$name for all failed logins$.$ From an audit perspective why would you want to know when individuals$/$applications failed to log in$?$

Write SQL that will return the date$-$time, target$\_$server$\_$principal$\_$name, server$\_$principal$\_$name for all login password changes. From an audit perspective why would you want to know when a login password was changed.

Write SQL that will return the date$-$time, database$\_$name, object$\_$name and statement for all new or created database users. From an audit perspective why would you want to know when a new database user is created?

Write SQL that will return the date$-$time and statement for all modified audits. From an audit perspective, why would you want to know when an audit is modified?