1. Write a SELECT statement that returns these columns from the Instructors table: a. The monthly salary (the AnnualSalary column divided by 12) b. A column that uses the CAST function to return the monthly salary with 1 digit to the right of the decimal point c. A column that uses the CONVERT function to return the monthly salary as an integer d. A column that uses the CAST function to return the monthly salary as an integer 2. Write a SELECT statement that returns these columns from the Students table: a. The EnrollmentDate column A column that uses the CAST function to return the EnrollmentDate column with its date only (year, month, and day) b. A column that uses the CAST function to return the EnrollmentDate column with its full time only (hour, minutes, seconds, and milliseconds) c. A column that uses the CAST function to return the EnrollmentDate column with just the year and month 3. Write a SELECT statement that returns these columns from the Instructors table: a. The AnnualSalary column b. A column named MonthlySalary that is the result of dividing the AnnualSalary column by 12 c. A column named MonthlySalary Rounded that calculates the monthly salary and then uses the ROUND function to round the result to 2 decimal places 4. Write a SELECT statement that returns these columns from the Students table: a. The EnrollmentDate column A column that returns the four-digit year that's stored in the EnrollmentDate column b. A column that returns only the day of the month that's stored in the EnrollmentDate column c. A column that returns the result from adding four years to the EnrollmentDate column; use the CAST function so only the year is returned 5. Write a SELECT statement that returns these columns: a. The DepartmentName column from the Departments table b. The CourseNumber column from the Courses table c. The FirstName column from the Instructors table d. The Last Name column from the Instructors table e. Add a column that includes the first three characters from the DepartmentName column in uppercase, concatenated with the CourseNumber column, the first character of the FirstName column if this column isn't null or an empty string otherwise, and the LastName column. For this to work, you will need to cast the Course Number column to a character column.

Are variables, decision structures, and loops used in other programming languages? How are the PL/SQL data types similar or different from variable types used in other languages?

Enter all of the various kinds of numerical information. In SQL

Why would you assume that two select statements from the same database are consistent?

When writing queries in a programming language, why should we avoid creating a query by concatenating strings and instead use prepared statements or stored procedures in defense against SQL injection?   a. concatenating strings helps prevent sql injection   b. prepared statements or stored procedures help prevent the user/hacker from deliberately modifying the query by injecting sql instructions in the input values   c. prepared statements prevent the query from taking as long to execute   d. prepared statements enable the developer to just supply values without injecting sql

Using the SQL GROUP BY phrase with a SELECT statement can help detect which of thefollowing problems?A) The multivalue, multicolumn problemB) The inconsistent values problemC) The missing values problemD) The general-purpose remarks column problem

I need help with creating the SQL statement for the instructions below. Create the following 2 tables with columns and constraints Table Lab4program_xxxx has 3 columns: code is varchar(5) and the primar key, name is varchar(20), tel varchar(20). Table Lab4course_xxxx has 3 columns: cid is int, and the primary key, name is varchar(20), credits is int, mycode is a foreign key reference to your Lab4program table. Table Lab4program_xxxx has 3 columns: code is varchar(5) and the primar key, name is varchar(20), tel varchar(20). Table Lab4course_xxxx has 3 columns: cid is int, and the primary key, name is varchar(20), credits is int, mycode is a foreign key reference to your Lab4program table.

python - Write the syntax for obtaining the index where X == 0.

Give specific examples of how the general meanings of calls and returns are shown.

By using this table answer this question: Write ONE SQL statement which uses the SUBSTR function (as many times as you need to) to extract the following three words: ‘I’, ‘am’, ‘here’ from the string ‘Where am I?’ and put the three words together using a combination of the CONCAT function and the ||.    E.g. The starting string used in the SQL statement is:  ‘Where am I?’          The output of the SQL statement after we run it will be:   TRANS ---------- I am here