The following is a table of applicants to be considered for admission into 07BSAM: POINTS MATH SYMBOL 123 450 NAMES STUDENT NUMBER ENG SYMBOL To qualify for admission, an applicant should have at least 25 points, minimum of B symbol in Mathematics and a minimum of E symbol in English. If an applicant has a C symbol in Mathematics, then the applicant must pass an entrance test to be considered for admission. Hints: There are three modes of study: The Full-time mode, the Part-time mode and the Distance mode. Applicants can choose which mode they want provided there is space in that mode. Each of the Full- time and the Part-time modes cannot accommodate more 30 admitted students. After these two modes are full, every other qualified applicant is admitted in the Distance mode. The admission exercise is first come first served. Write a pseudocode that identifies the applicants that qualify for admission and outputs their names, student numbers and modes of study. Use a FOR-LOOP /…

r and l values question.

Computer Science please please any help ASAP   Query #5: Code a query that will make use of SQL Server intrinsic functions and reference the Instructors table. Must have alias names for each column. First column: Display the instructors name as first name initial followed by a period and space and then last name such as B. Brown Second column: Display the year only for the hire date. Third column: Difference in months between today’s date and the hire date. Last column: Display the string literal ‘Full-time instructor’ if an instructor has a Status of F or return the string literal of ‘Adjunct instructor’ if they have a status of P. You can use the Case function or the IIF function.

DEPTNO | START DATE EMP NO | EMP NAME | EMP COMM DEPTNΟ DEPT ΝΑΜΕ MIN SAL | ΜAX SAL DEΡΤΝΟ EMP EMP SAL DEPT a) Display the name, salary, and commission for all employees who earn commissions. Sort data in descending order according to salary and commissions. b) For each employee, display the employee's last name, and calculate the number of months between today and the date the employee was hired. Label the column MONTHS_WORKED. Order your results by the number of months employed. Round the number of months up to the closest whole number. c) Display the employee name and department name for all employees who have an a (lowercase) in their last names.

a) Display title of last book. b) Showing only title of books having price below 30 c) Find book not written in German language. d) Find books having price between 30 to 50 e) Find titles book having title more than 20 characters long.

PATHS is a table that contains information about paths on a number line. The structure of PATHS is as follows, where x1 and x2 represent that there is a path from Coordinate x1 to Coordinate x2 (You can't move from Coordinate x2 to Coordinate x1 ). NAME ΤΥΡE NULLABLE X1 INT FALSE X2 INT FALSE Problem Please write an SQL statement that returns the beginning and end point of each path in PATHS . Sort them by the value of the beginning point in ascending order. Constraints • In the case where a direct path from Coordinate a to Coordinate b is available, no path from Coordinate b to Coordinate a will be given. |x1-x2| = 1 • No path will overlap with one another. Example Suppose that PATHS is as follows: x1 x2 1 2 2 3 4 7 7 6 This table can be visualized as follows: START END END START 7 8. 9 Therefore, your SQL statement must return the following: start end 1 4 8 6

( Please answer this question immediately I do not have time ) Use the following table to answer the questions below:     Table name: Books     Column Name Role Data Type Length Constraint bookID Stores the ID of a book Number 5 Primary key bookTitle Stores the title of a book Varchar2 50 - bookISBN Stores the ISBN of a book Number 13 Cannot be null and duplicated publicationDate Store the publication date of a book Date - Cannot be null bookPrice Stores the price of a book Number 2,2 Cannot be null a. Write in SQL a command that creates the table Books according to the above description b. Write in SQL a statement that adds a new column named publisherID of type Char(10). This column should be defined as a foreign key that relates the table Books to the table Publisher c. Write in SQL a command that deletes the books that are published before 20-Aug-2010 d. Write a SQL query that displays the number of books that are published in the year 2018 e. Write in SQL a…

Need only correct .else downvoted.

Display all the student names whose grade is C. Display the Section-Identifier and Course-name whose Course-number is “MATH2410”. Display the Student Name and the Course Name in which he has got “A” grade.