in sql ,create  a  program that prompts the user for a number. This number will be top (cap) number. And your program will find out all the even and odd numbers in between  1 to this max number.   The program should continue to find odd and even numbers from 1 to maximum number given (entered) by user… If user input is less than or equal to zero Program should not even start doing its task and right away print ‘Sorry I can not calculate odd and even numbers for negative or zero’  …  But when user entered any positive number then the program should display all numbers as either even or odd.

Q: This is a database system question regarding SELECT: Which of the following statements is true for…

A: The above question is solved in step 2:-

Q: Unlimited tries Assume cur is a Cursor object, the variable name_input references a string and the…

A: Python: Python is an interpreted high-level programming language noted for its ease of use,…

Q: I want solution flowchart

A: Given Pseudocode/code:   Start Step 1: Declare Student_Name[10], Student_Score[10][5],i=0,j=0,sum=0…

Q: Prompt the user for a title for data. Output the title. Ex: Enter a title for the data: Number of…

A: Since the programming language is not mentioned in the question, we will answer this question in the…

Q: reate a PL/SQL block using a FOR loop to generate a payment schedule for a donor’s pledge, which is…

A: ANSWER:-

Q: Create a program (using sQL strings) that willinsert one record, increase by 8 % the unit price of…

A: the answer is given below :

Q: ntacts Database) Study the books.sql script provided in the ch17 examples folder's sql subfolder.…

A: Answer is below:

Q: A computer store uses a database to track inventory. The database has a table named Inventory , with…

A: Import necessary modules. The following line imports the sqlite3 module, which is a Python module…

Q: Exercise 1 Write a code to check the number in the variable (NUM1). Using the lookup table; store…

A: The code is given below.

Q: get_column_choice(): this function will allow us to ask the players which pocket they want to grab…

A: Hey there, I am writing the required solution based on the above given question. Please do find the…

Q: Develop a two small PL/SQL programs. 1. Enter students ID from the keyboard. The program then…

A: here i mentioned PL/SQL small two programs for given problem. also handled NO_DATA_FOUND and…

Q: Create a function in your own database that takes two parameters: A year parameter A month…

A: Database: A database is a set of data that has been arranged for easy access and management. To…

Q: Please Help Correct This Error   // Create Horse table public static void createTable(Connection…

A: The error message suggests that the createTable() method did not create the Horse table…

Q: Ineed help to create a nested formula in cell B17 with the IF and SUM functions that check if the…

A: For the solution of this inquiry let us take an example of relevant datasheet as below : Suppose…

Q: Computer Science * IN SQL* Write an SQL statement that selects all customers with a city starting…

A: selects all customers with a city starting with any character, followed by "land".

Q: A computer store uses a database to track inventory. The database has a table named Inventory , with…

A: The Python code executes an SQL statement using the Cursor object to update the rows in the…

Q: What is stored in score1, score2, and grade? 0 Integer score1 - 72; int score2-85; Character grade -…

A: Given lines of code are, Integer score1 = 72; int score2 = 85; Character grade = 'C'; It contains…

Q: The file named Ch21p1.xlsx contains data about unit sales for 11 products during the years…

A: The answer is as follows.

Q: start end 1 8 6

A: -- sql-- select start only if x1 = x2 - 1 is satisfied-- select end as max if x2 = x1 + 1 is…

Q: Create a metric distant conversion program(PL/SQL) Ask user three questions and collect them with &…

A: Please refer to the following steps for the complete solution to the problem above.

Q: PYTHON CODE Using Artists.csv (link below), write a query that returns all lines that are female…

A: It is defined as a powerful general-purpose programming language. It is used in web development,…

Q: Which of the following is not a correct statement?a. A table can be modified only if it doesn’t…

A: UPDATE command: The UPDATE command is employed to update information present in a table. It is…

Q: 10. Please write a stored function named fHW_10_xxxx () which will return the total payment amount…

A: Solution: Considering the name of the schema(database) is student_db. MySQL query for creating…

Q: Fill in the loop table with the correct values. Each row should represent the values of the…

A: Explanation:-

Q: The HAVING clause applies to columns and expressions for individual rows, while the WHERE clause is…

A: Refer to step 2 for the answer.

Q: 17. Write the SQL statement that will display the following (do not hardcode 'George', 'Lorraine',…

A: Using self join between these two table we will get the results for George and Lorraine and to…

Q: (1) Prompt the user for a title for data. Output the title.  Ex: Enter a title for the data:…

A: Our guidelines is answer the first three question from the first question and we have done first…

Q: B See Balance //prints current balance D Make Deposit //get deposit amount from user and adds…

A: The program should ask the user to enter the balance: 4 choices: balance, deposit, withdrawal, Exit…

Q: Write dynamic SQL statements: a) Based on controls on the main search screen, write SQL statement to…

A: a) write dynamic SQL statements: a)Based on the controls of main search screen, write SQL statement…

Q: On the Faculty Data worksheet, in cell J3, use an IFS function to calculate the retirement matching…

A: The excel formula  is used here to calculate the desire result,  the excel formula in cell J3 . In…

Q: Write a stored procedure called sp_apply_discount() that will apply percent discount to books in a…

A: Database:         An organized group of data that can be electronically stored and retrieved is…

Q: The Movie table has the following columns: ID - positive integer Title - variable-length string…

A: In the dynamic landscape of relational databases, the ability to modify existing tables is crucial…

Q: Rewrite the code below to display one column called "Customer Full Name" (In which the first and…

A: Solution:   Given, Rewrite the code below to display one column called "Customer Full Name" (In…

Q: I want solution flowchart Start Step 1: Declare Student_Name[10],…

A: Flowchart: Flowchart is used to represent the workflow or process. It uses standard symbols to…

Q: For name= "Michael", what is the output of the function Lpad(name,10,") ? O a. Michael*** O b.…

A: Here, Question with options is given.

Q: Translate the following pandas statement in Python to a SQL query so that it can be executed on the…

A: In above statement I. 10*dfdata['case']-->mean multiple each row of 'case'(may consist number)…

Q: Based on the table below, what values would appear in range C4:E6 when the contents of C3:E3 are…

A:

Q: Task 1: Generate the truth table for a 7-segment display. XYZ A B C D E F G 00011 0010 010 1 1 0 1 1…

A: Let's create a K maps for 3 input and 7 segment output.