Programming & Computer Science Answers

Create a program that will display the corresponding college level of s given input year level. The year and the college are given below:

Note: Use if else if statement.

Year Level College Level

1 Freshmen

2 Sophomore

3 Junior

4 Senior

Other years Unlisted Level

Get the number of male and female premium users in the platform.

As mentioned above, We need to count the users who has the premium membership, but you are trying to sum instead of count(). And also in the WHERE clause, we need to check premium users have premium_membership value as 1 , and the value 0 is considered as non-premium user.

Table: USER

user_id name gender age country premium_membership

2000 John White M 63 AUSTRALIA 1

2001 John Andrews M 67 AUSTRALIA 1

2002 April Robinson F 60 SRILANKA 1

2003 Kathy Ryan F 81 SRILANKA 0

2004 Megan Bradshaw F 53 AUSTRALIA 1

2005 Melissa Sullivan F 45 BANGLADESH 1

there is still having lot of data in the table, but I just gave the limited data for example to get the solution related to question and the expected output format should be as follows:

Table: gender total_users

F ...

M ...

design a c++ program with using and without using virtual function getdata() and putdata() to read and display the details of student such as sname,sregno and address?

Write a program that will allow the user to input two (2) numbers and mathematical operation (+, -, *, /).

Requirements：

(1) Write a program that declares a single-dimensional arrays named num.

(2) The numbers to be stored in num are 45, 86, 12, 37, 28, 113.

(3) Sum odds and evens separately.

(4) Finally, give the results that will be displayed on the screen.

Requirements：

(1) Please enter the value of a year through the keyboard.

(2) Please program to determine whether the entered year is a leap year.

(3) The conditions for a leap year are: divisible by 4 but not divisible by 100; or divisible by 400.

Project 3: Application of if statement

Requirements：

(1) Please program to judge the positive and negative and odd and even of an input integer.

(2) If it is a positive number, please output z; if it is a negative number, please output f.

(3) If it is an even number, please output o; if it is an odd number, please output j.

Requirements：

(1) Convert the inputted 3-digit integer, the single digit to a hundred digit, and the hundreds digit to a single digit, and generate a new inverted number from the converted 3 digits.

(2) Arbitrary 3-digit integers are input by keyboard.

(3) When outputting the result, the required form is: original number: converted number.

(1) Please enter any character from the keyboard.

(2) Please let the computer output two lines: the first line is in the form of characters, 3 characters are output, the 3 characters are separated by commas, and the second line is the ASCII code corresponding to the output characters.

/*7. Show any employee who is not a manager, but earns more than any manager in

the employees table. Show first name, last name, job id, and salary. Sort the result 

by salary.*/

What are some ways of writing is query?