The given SQL creates a Movie table with an auto-incrementing ID column. Write a single INSERT statement immediately after the CREATE TABLE statement that inserts the following movies:
Title Rating Release Date
Raiders of the Lost Ark PG June 15, 1981
The Godfather R March 24, 1972
The Pursuit of Happyness PG-13 December 15, 2006
Note that dates above need to be converted into YYYY-MM-DD format in the INSERT statement. Run your solution and verify the movies in the result table have the auto-assigned IDs 1, 2, and 3.
CREATE TABLE Movie (
ID INT AUTO_INCREMENT,
Title VARCHAR(100),
Rating CHAR(5) CHECK (Rating IN ('G', 'PG', 'PG-13', 'R')),
ReleaseDate DATE,
PRIMARY KEY (ID)
);
-- Write your INSERT statement here:

Answers

Answer 1

Answer:

INSERT INTO Movie(Title,Rating,ReleaseDate)

VALUES("Raiders of the Lost ArkPG",'PG',DATE '1981-06-15'),

("The Godfaher",'R',DATE '1972-03-24'),

("The Pursuit of Happyness",'PG-13',DATE '2006-12-15');

Explanation:

The SQL statement uses the "INSERT" clause to added data to the movie table. It uses the single insert statement to add multiple movies by separating the movies in a comma and their details in parenthesis.


Related Questions

You should write the client so that it sends 10 ping requests to the server, separated by approximately one second. Each message contains a payload of data that includes the keyword PING, a sequence number, and a timestamp. After sending each packet, the client waits up to one second to receive a reply. If one second goes by without a reply from the server, then the client assumes that its packet or the server's reply packet has been lost in the network.Hint: Cut and paste PingServer, rename the code PingClient, and then modify the code. The two programs follow very similar process.You should write the client so that it starts with the following command:java PingClient host portwhere host is the name of the computer the server is running on and port is the port number it is listening to. Note that you can run the client and server either on different machines or on the same machine.The client should send 10 pings to the server. Because UDP is an unreliable protocol, some of the packets sent to the server may be lost, or some of the packets sent from server to client may be lost. For this reason, the client cannot wait indefinitely for a reply to a ping message. You should have the client wait up to one second for a reply; if no reply is received, then the client should assume that the packet was lost during transmission across the network. You will need to research the API for DatagramSocket to find out how to set the timeout value on a datagram socket.When developing your code, you should run the ping server on your machine, and test your client by sending packets to localhost (or, 127.0.0.1). After you have fully debugged your code, you should see how your application communicates across the network with a ping server run by another member of the class.Message FormatThe ping messages in this lab are formatted in a simple way. Each message contains a sequence of characters terminated by a carriage return character (r) and a line feed character (n). The message contains the following string:PING sequence_number time CRLFwhere sequence_number starts at 0 and progresses to 9 for each successive ping message sent by the client, time is the time when the client sent the message, and CRLF represent the carriage return and line feed characters that terminate the line.

Answers

Answer:

figure it out urself

Explanation:

Which artistic technique uses multiple layers of small calligraphic or scribbled marks?
A. random hatching
B. crosshatching
C. shading
D. stippling
E. scrumbling

Answers

I would go with C.shading. It just makes the most sense

Answer:

E. scrumbling

Explanation:

lower cabinet is suitable for storing and stocking pots and pans true or false​

Answers

True.
Make sure cabinet is clean enough to put the pots and pans.

2. It is the art of creating computer graphics or images in art, print media, video games.
ins, televisions programs and commercials.

Answers

the answer is CGI :)

what is the file extension if the file editing​

Answers

Explanation:

"A file extension (or simply "extension") is the suffix at the end of a filename that indicates what type of file it is. For example, in the filename "myreport. txt," the . TXT is the file extension.Sometimes long file extensions are used to more clearly identify the file type."

Add (11011)2 + (111)2​

Answers

Answer:

(11011)2+(111)2=(100010)2

hope it helps.

Answer:

(100010)square is the correct answer Hope it helps you have a great day keep smiling be happy stay safe ☺

3. Given the following total revenue functions, find the corresponding demand functions:

a) TR = 50Q-4Q²
b) TR = 10

Answers

a)TR=50Q4Q2 I hope.this helps

A) The demand function for the total revenue function TR = 50Q - 4Q² is;

P = 50 - 4Q

B) The demand function for  the total revenue function TR = 10 is; 10/Q

We are given total revenue functions as;

TR = 50Q - 4Q²

TR = 10

A) TR = 50Q - 4Q²

Formula for revenue function if Q represents the units demanded is;

TR = P × Q

Where P is the demand function

Thus;

50Q - 4Q² = PQ

Divide both sides by Q to get the demand function;

P = 50 - 4Q

B) TR = 10

Formula for revenue function if Q represents the units demanded is;

TR = P × Q

Where P is the demand function

Thus;

10 = P × Q

Divide both sides by Q to get the demand function;

P = 10/Q

Read more at;https://brainly.com/question/13701068

Explain the complement of a number along with the complements of the binary and decimal number systems.why is the complement method important for a computer system?​

Answers

olha so olha la que bacana bonito

The complement method are the digital circuits, are the subtracting and the addition was the faster in the method.  The binary system was the based on the bits are the computer language.

What is computer?

Computer is the name for the electrical device. In 1822, Charles Babbage created the first computer. The work of input, processing, and output was completed by the computer. Hardware and software both run on a computer. The information is input into the computer, which subsequently generates results.

The term “binary” refers to the smallest and minimum two-digit number stored on a computer device. The smallest binary codes are zero (0) and one (1). The use of storing numbers easily. The computer only understands the binary language. The binary is converted into the number system as a human language. The complement method are the digital circuits the addition and the subtracting was the easily.

As a result, the complement method is the digital circuits are the subtracting to the binary system was the based on the bits are the computer language.

Learn more about on computer, here:

https://brainly.com/question/21080395

#SPJ2

Binary is a base-2 number system instead of the decimal (base-10) system we are familiar with. Write a recursive function PrintInBinary(int num) that prints the binary representation for a given integer. For example, calling PrintInBinary(5) would print 101. Your function may assume the integer parameter is non-negative. The recursive insight for this problem is to realize you can identify the least significant binary digit by using the modulus operator with value 2. For example, given the integer 35, mod by 2 tells you that the last binary digit must be 1 (i.e. this number is odd), and division by 2 gives you the remaining portion of the integer (17). What 's the right way to handle the remaining portion

Answers

Answer:

In C++:

int PrintInBinary(int num){

if (num == 0)  

 return 0;  

else

 return (num % 2 + 10 * PrintInBinary(num / 2));

}

Explanation:

This defines the PrintInBinary function

int PrintInBinary(int num){

This returns 0 is num is 0 or num has been reduced to 0

if (num == 0)  

 return 0;  

If otherwise, see below for further explanation

else

 return (num % 2 + 10 * PrintInBinary(num / 2));

}

----------------------------------------------------------------------------------------

num % 2 + 10 * PrintInBinary(num / 2)

The above can be split into:

num % 2 and + 10 * PrintInBinary(num / 2)

Assume num is 35.

num % 2 = 1

10 * PrintInBinary(num / 2) => 10 * PrintInBinary(17)

17 will be passed to the function (recursively).

This process will continue until num is 0

Here is the problem specification: An Internet service provider has three different subscription packages for its customers: Package A: For $9.95 per month 10 hours of access are provided. Additional hours are $2.00 per hour. Package B: For $14.95 per month 20 hours of access are provided. Additional hours are $1.00 per hour. Package C: For $19.95 per month unlimited access is provided. Write a program that calculates a customer's monthly bill. It should ask which package the customer has purchased and how many hours were used. It should then display the total amount due. Input Validation: Be sure the user only selects package A, B or C. Also, the number of hours used in a month cannot exceed 744. Use switch.

Answers

Answer:

In C++:

#include <iostream>

using namespace std;

int main(){

   int hour; char pkg; float bill = 0;

   cout<<"Package: "; cin>>pkg;

   cout<<"Hour: "; cin>>hour;

   if(hour<=744 && hour >=0){

       switch (pkg) {

           case 'A':

               bill = hour * 9.95;

               if(hour >10){bill = 10 * 9.95 + (hour - 10) * 2;}

           break;

           case 'B':

               bill = hour * 14.5;

               if(hour >10){bill = 20 * 14.5 + (hour - 20) * 1;}

           break;

           

           case 'C':

               bill = 19.95;

           break;

           

           default:

               cout << "Package must be A, B or C";}

cout<<"Total Bills: $"<<bill; }

else{ cout<<"Hour must be 0 - 744"; }

return 0;

}

Explanation:

This declares all variables:    int hour; char pkg; float bill=0;

This prompts the user for package type:  cout<<"Package: "; cin>>pkg;

This prompts the user for number of hours:    cout<<"Hour: "; cin>>hour;

This checks if hour is between 0 and 744 (inclusive)

   if(hour<=744 && hour >=0){

If true, the following is executed

A switch statement to check valid input for package

       switch (pkg) {

For 'A' package

           case 'A':

Calculate the bill

               bill = hour * 9.95;

               if(hour >10){bill = 10 * 9.95 + (hour - 10) * 2;}

End of A package:            break;

For 'B' package

           case 'B':

Calculate the bill

               bill = hour * 14.5;

               if(hour >10){bill = 20 * 14.5 + (hour - 20) * 1;}

End of B package:            break;

For C package            

           case 'C':

Calculate bill:                bill = 19.95;

End of C package:            break;

If package is not A, or B or C

           default:

Prompt the user for valid package                cout << "Package must be A, B or C";}

Print total bills: cout<<"Total Bills: $"<<bill; }

If hour is not 0 to 744: else{ cout<<"Hour must be 0 - 744"; }

Explanation historical development of computer ​

Answers

Answer:

Brief History Of Computer. The computer as we know it today had its beginning with a 19th century English mathematics professor name Charles Babbage. ... Other developments continued until in 1946 the first general– purpose digital computer, the Electronic Numerical Integrator and Computer (ENIAC) was built.

Explanation:

Computers and electronics play an enormous role in today's society, impacting everything from communication and medicine to science.

Although computers are typically viewed as a modern invention involving electronics, computing predates the use of electrical devices. The ancient abacus was perhaps the first digital computing device. Analog computing dates back several millennia as primitive computing devices were used as early as the ancient Greeks and Romans, the most known complex of which being the Antikythera mechanism. Later devices such as the castle clock (1206), slide rule (c. 1624) and Babbage's Difference Engine (1822) are other examples of early mechanical analog computers.

The introduction of electric power in the 19th century led to the rise of electrical and hybrid electro-mechanical devices to carry out both digital (Hollerith punch-card machine) and analog (Bush’s differential analyzer) calculation. Telephone switching came to be based on this technology, which led to the development of machines that we would recognize as early computers.

The presentation of the Edison Effect in 1885 provided the theoretical background for electronic devices. Originally in the form of vacuum tubes, electronic components were rapidly integrated into electric devices, revolutionizing radio and later television. It was in computers however, where the full impact of electronics was felt. Analog computers used to calculate ballistics were crucial to the outcome of World War II, and the Colossus and the ENIAC, the two earliest electronic digital computers, were developed during the war.

With the invention of solid-state electronics, the transistor and ultimately the integrated circuit, computers would become much smaller and eventually affordable for the average consumer. Today “computers” are present in nearly every aspect of everyday life, from watches to automobiles.

The history of computers is one that began far back 2000 years ago in the city of Babylonia where there was the use of  abacus and it has grown to now the use of digital computer as it start in 1642. ​

What is  the history of computer?

The history of computers is one that is more than 200 years but in the 19th century, there was the invention of  mechanical calculating machines.

Note that the The 1st generation of computers was said to have existed from the year 1940 to 1955 and now it has grown to a whole new level.

Learn more about computer from

https://brainly.com/question/24540334

#SPJ9

Have you ever tried using such a camera?​

Answers

Answer: yeah i mean i use my canon camera

Explanation:

____________ reference is used when you want to use the same calculation across multiple rows or columns.

Answers

Answer:

relative cell

Explanation:

So, if you want to repeat the same calculation across several columns or rows, you need to use relative cell references. For example, to multiply numbers in column A by 5, you enter this formula in B2: =A2*5. When copied from row 2 to row 3, the formula will change to =A3

Answer:

Relative

Explanation:

Relative  reference is used when you want to use the same calculation across multiple rows or columns.

where are all of your documents saved?

Answers

Answer:

create a my document folder so you can easily find it

name 2 kitchen tools equipment or materials you are going to store or stack in the following drawers and cabinet 1.flat drawer 2.upper cabinet 3 . Small drawer near countertops 4.Lower cabinets 5.Lower cabinets under the sink​

Answers

Answer:

silverware and dishwasher chemicles

Explanation:

Was Nick Carson a good project manager? Why or why not?

Answers

Answer:

Nick Carson is not a good project manager because he did not focus on all aspects of the project. He also failed to provide accurate schedules and also detailed plans on the happenings of the project. He was performing other jobs leaving aside the work of project manager. Without concerning and understanding the problem of top management he delivered the project.

Explanation:

the _ and _ services help us to keep in touch with our family and friends

Answers

Answer:

Internet and communication technology

Explain different types of networking-based attacks

Answers

Answer:

Network-based cyber attacks. ... These may be active attacks, wherein the hacker manipulates network activity in real-time; or passive attacks, wherein the attacker sees network activity but does not attempt to modify it

This component of the CPU is responsible for fetching the data, converting it, and de-converting
A) ALU
B) RAM
C) Control Unit
D) None of the above

Answers

Answer : C.Control Unit

Reason

In CPU there are two components name ALU and CU(Control unit) which ALU's function is to solve mathematic sequence and CU fuction is to vetch data to memory and manage commands and input & output.

#See pic for how the data proceed

1
When collection of various computers
look like a single coherent system to its
client, then it is called​

Answers

Answer:

The appropriate answer is "Distributed system".

Explanation:

Whenever used by linking several autonomous computers as a single system, considered as distributed system. It could be consist of several kinds of  mainframes, processors as well as stationary machines, it can be programmed. A distributed machine has massive program modules, which operate as a single device on many machines.

What is Open Source Software​

Answers

Answer:

Open-source software is a type of computer software in which source code is released under a license in which the copyright holder grants users the rights to use, study, change, and distribute the software to anyone and for any purpose

Explanation:

who is the father of computer?
1.Charles Babbage 2.James Waat​

Answers

Answer:

its 1 Charles babbage

Explanation:

shjdjdjdjdjdj

Answer:

Si Charles Babbage,

Explanation:

FRS ay isang Ingles na matematiko, pilosopo, imbentor, at inhinyerong mekanikal na nagpanimula ng konsepto ng isang naipoprogramang kompyuter. Nakatanghal ang mga bahagi ng kanyang hindi pa buong mga mekanismo sa Museo ng Agham sa London.

State and give reason, if the following variables are valid/invalid:
Variables defined in Python
Valid/Invalid
Reason
daysInYear


4numberFiles


Combination-month_game


Suncity.school sec54


Answers

Answer:

See Explanation

Explanation:

Variable: daysInYear

Valid/Invalid: Valid

Reason: It begins with a letter; it is not a keyword, and it does not contain a hyphen

Variable: 4numberFiles

Valid/Invalid: Invalid

Reason: It begins with a number

Variable: Combination-month_game

Valid/Invalid: Invalid

Reason: It contains a hyphen

Variable: Suncity.school sec54

Valid/Invalid: Invalid

Reason: It contains a dot and it contains space

If columns are labelled alphabetically, what will be the label for the cell in row 1, column 16,384?

Answers

AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA

Hope this helps!

1. Which of the following is used to operate computers and execute tasks?
A. Software
C. Update
B. Application
D. Upgrade

Answers

I wish I could get the new app to play this app and it is great for the iPad version

Answer:

a.software

I hope it hel

О OF
Types icts commonly
in education.
used​

Answers

Answer:

The types of the itcs can be defined as follows:

Explanation:

It stands for the information and communication technology, which is used to comprises products that are a store, process, pass, transform, replicate or receive digital communications. 

It applies to all technology of interaction, such as the Internet, wireless networks, devices, laptops, middleware, video - conferencing, social media, and other software and services in media, and the four types in which it is used in education can be defined as follows:

(i) networking for education

(ii) Web-based education

(iii) mobile education

(iv) facilities for the classroom

Methods ii.) Define and implement a method that takes a string array as a parameter and returns the length of the shortest and the longest strings in the array i.) Write a method that take an integer array as a parameter and returns the sum of positive odd numbers and sum of positive even numbers. iii.) Implements the sequential search method that takes and array of integers and the item to be search as parameters and returns true if the item to be searched in the array, return false otherwise

Answers

Answer:

Explanation:

Well I am sorry I don't know the answer anyway.

Write a program that asks the user to enter five test scores. The program should display a letter grade for each score and the average test score. Write the following methods in the program: calcAverage: This method should accept five test scores as arguments and return the average of the scores. determineGrade: This method should accept a test score as an argument and return a letter grade for the score, based on the following grading scale:

Answers

Answer:

See comment for complete question

#include <iostream>

using namespace std;

double calc_Average(double sc1, double sc2, double sc3, double sc4, double sc5){

   return (sc1 + sc2 + sc3 + sc4 + sc5)/5;

}

char determine_Grade(double score){

   char grade;

   if(score >= 90 && score <=100){

       grade = 'A';}

   else if(score >= 80 && score <90){

       grade = 'B';}

   else if(score >= 70 && score <80){

       grade = 'C';}

   else if(score >= 60 && score <70){

       grade = 'D';}

   else if(score <60){

       grade = 'F';}

   return grade;

}

int main(){

   double sc1,sc2, sc3, sc4, sc5;

   cout<<"Enter 5 scores: ";

   cin>>sc1>>sc2>>sc3>>sc4>>sc5;

   cout<<"Score: "<<sc1<<" Grade: "<<determine_Grade(sc1)<<endl;

   cout<<"Score: "<<sc2<<" Grade: "<<determine_Grade(sc2)<<endl;

   cout<<"Score: "<<sc3<<" Grade: "<<determine_Grade(sc3)<<endl;

   cout<<"Score: "<<sc4<<" Grade: "<<determine_Grade(sc4)<<endl;

   cout<<"Score: "<<sc5<<" Grade: "<<determine_Grade(sc5)<<endl;

   double Ave = calc_Average(sc1,sc2,sc3,sc4,sc5);

   cout<<"Average: "<<Ave<<" Grade: "<<determine_Grade(Ave)<<endl;

   return 0;

}

Explanation:

The program was written in C++. Because of the length of the explanation, I've added the explanation as an attachment where I used comments to explain the lines of the code.

I need help Asap!!! So the question is "Compare and contrast Web page and Websites". ​

Answers

Answer:

A website is a mix of web pages while a web page is a single entity.

Explanation:

What are the three types of networks?
A) Internet, PowerPoint, Excel
B) Internet, LAD, WAN
C) Internet, WAN, LAN
D) None of the above

Answers

Answer:

Local Area Network (LAN)

Metropolitan Area Network (MAN)

Wide area network (WAN)

(So C, I'm pretty sure.)

Answer:

LAN,MAN,WAN

Explanation:

are the three types of network
Other Questions
Ice ages are what climate changes that occur when Earth's what is more what than it is today What is the slope of the red and blue line Dear LucyThank you for your letter. I like it.We likes. We have a big farm.We haveanimals on our farm. We havethreeand threetwoandfourfiveand twoMadina and I have three and four_and sevenAziz and Davron havetwo_and eightandthreeThe dog's name is Olapar.My father has a - and aPlease write to me soon.LoveSabina-, a how many 1/2 inch cubes does it take to fill a rectangular prism with a length of 1 inch, a width of 2 inches and a height of 3 inches GIVING POINTS AND BRAINLIEST!!! After how many years does a Utah driver's license expire? HELPPPPPPPPP!! ASAP IT WOULD BE GREATLY APPRECIATED PLEASE PLEASE HELP IM BEGGING can earn 5 coinsWhich of the following situations are equal to 5? Select all that apply.A) 25% of 20B) 10% of 50C) 10% of 40D) 50% of 10E) 50% of 8 In "The Whippoorwill," what is the speaker's viewpoint of the whippoorwills call?(A) He finds it annoying and disruptive to the calm.(B) It is beautiful, and he wishes he could hear it more.(C) It makes him feel sad that the day is coming to an end.(D) It makes him wish that more birds lived near him. PLEASEEEEEE HELP I WILL MARK BRAINLIEST!!!!!!!!!!!!!!! Is 1,48 rational or irrational My mama set a lone plate for me on the sideboard in the kitchen. That was truly the first time I felt unwanted in my daddys family. My daddy hadnt even bothered to tell me himself not to sit at his table. He had left that to my mama, and I resented not only him for it, but her too. You sit down, my mama said, and Ill fix your plate. You dont have to fix me anything, I said, pouting. Itll be the same food Ive cooked for your daddy. I don't want it. Paul, you hafta eat. Not in this house, I said, and left. Paul-Edward! she called after me. Boy, dont you go no farthern them steps! You hear me? I heard her, all right. I just didnt admit I did. I walked the back side of the veranda, out of my mamas view, and leaned against a post and looked out across the backyard to my daddys forest. The Land, Mildred D. Taylor What is the conflict? Why does the conflict happen? What will it take to resolve the conflict? Hey lol pls help meim rlly bad at math The function of the thesis statement of an essay is toOgrab the attention of readers with a quote.list specific details and facts to prove them.Oprovide readers with the main idea of the essay.wrap up an essay with a good summary.(this is critical thinking please help) |x-4|+6=13 solve this equation Select the correct answer.Which verb best completes the sentence?Il fautles factures avant la date limite.OA dpenser.payer.retirerOD. dposerSomeone help quickly Find the area of the shape. Grace bought 3 soccer balls for $14 each and 2 pairs of goalie gloves for $9 each. Write an expression for the total cost of the supplies. Then find the total cost. (LABEL) What are some examples of inequality in the U.S. now and in the past?