I am writing a Python code to ask a user to enter students' information including name,
last name and student ID number. The program should continue prompting the
user to enter information until the user enters zero. Then the program enters
search mode. In this mode, the user can enter a student ID number to retrieve
the corresponding student's information. If the user enters zero, the program
stops. Please help!​

Answers

Answer 1

Answer:

student_file = {}

endf_input = '1'

for x in iter(list, 1):

   name = input("Enter a student name: ")

   st_id = int(input("Enter a student id number: "))

   student_file[name] = st_id

   endf_input = input("Add more student to file (type 1 for yes and 0 to end): ")

   if endf_input == '0':

       break

print("Search for Student")

search = int(input("Enter student id: "))

if search == 0:

   print("Sorry, no student with id of zero.")

   quit()

for key, value in student_file.items():

   if value == search:

       print(f"Student name: {key}")

Explanation:

The program source code uses a for loop to continuously add data to the student file dictionary structure but breaks from the loop when a zero is received as input. The program enters search mode and returns the name of the student with the searched id number.


Related Questions

An IT systems engineer creates a new Domain Name System (DNS) zone that contains pointer (PTR) resource records. Which zone type has been created?

Answers

Answer:

SOA

Explanation:

Statement of Authority, or you could also say that the zone that has been created is a reverse lookup

A technology that can help a student to increase his or her understanding of the vocabulary used in a classroom is called:_______

a. assistive instruction.
b. UDL technology.
c. hypertext software.
d. adaptive instruction.

Answers

Answer:

c. hypertext software.

Explanation:

In Computer science, a hypertext can be defined as textual informations that are being displayed on a computer system and these texts usually links to other informations (texts) that the user can easily have access to in real-time.

Basically, some developers include encyclopedias and dictionaries in their software database, which makes other necessary informations or contents easier and immediately accessible to the users through the use of hypertexts that is activated by pointing and clicking on the link with a mouse, keypress set or soft touching the screen.

Hence, a technology that can help a student to increase his or her understanding of the vocabulary used in a classroom is called hypertext software.

A company has three (3) components in a system and requires all three to be operational for 24 hours, Monday to Friday. Failure of component 1 occurs as follows: Monday = No failure. Tuesday = 5 a.m. to 7 a.m. Wednesday = No failure. Thursday = 4 p.m. to 8 p.m. Friday = 8 a.m. to 11 a.m. Directions: Using the scenario above, respond to the items below. Calculate the MTBF (Mean Time Between Failures) and MTTR of component 1. Show your steps of how you calculated the MTBF. Steps: MTBF = Total Uptime / Number Failures Total Uptime = (Number of Days Required Operational x Hours per Day Available) - Number of Hours Not Available MTTR = Total Downtime / Number of Failures What does the MTBF measurement tell you about the goal of having 99.999% uptime or Information Availability on system components?

Answers

Answer:

Following are the code to this question:

#include<stdio.h>//defining header file

//using namespace std;

int main()//defining main method

{

float MTBF, MTTR, Total_up;//defining float variable

Total_up = (4 * 24) - 9;//defining Total_up variable that calculate Total uptime value

MTBF = Total_up / 3.0;//defining MTBF variable that calculate its value

MTTR = 9 / 3;//defining MTTR that calculate its value

printf("\n The total value of MTBF: %f",MTBF);//print value with message

printf(" \n The total value of MTTR: %f ",MTTR);//print value with message

return 0;

}

Output:

The total value of MTBF: 29.000000  

The total value of MTTR: 3.000000  

Explanation:

In the above-given code, three float variable "MTBF, MTTR, and Total_up" is defined, in the next step the "Total_up" variable is defined, that holds a value to calculate its value.

In the next step, the "MTBF, and MTTR" variable is defined, and in the "MTBF" variable, it uses Total_up variable value to calculate its value and use the print method to print the "MTBF and MTTR" value.

What is the computer software? Does a hardware can work without software?

Answers

Answer:

Hope this helped!

Explanation:

A computer software is anything that lets you work with computers what happens inside it, and hard ware is the actual computer and its parts, so no a computer hardware CANNOT work without a software.

Answer:

computer software is the collection of data or computer instructions that tell computer how to work.

Hardware and software are interconnected to each other, with software the hardware of computer wouldn't have any function.

what's a good online University to attended for cyber security certificate.?

Answers

Answer:

If your in the UK, a great university to attend is Lancaster University for a cyber security certificate.

Explanation:

Describe two circumstances where access services might get implemented by organizations please.​

Answers

Answer:

Answered below

Explanation:

Remote access enables access to an organisations network from remote places. Certain conditions require such access. An organisation might require their workforce to work from home especially in this coronavirus health pandemic situation. Therefore remote access is necessary.

Also attending to customers needs, virtual meetings and connections to workers and clients all over the world, can only be made possible by the implementation of secured remote access, by the organisation.

Mad Libs are activities that have a person provide various words, which are then used to complete a short story in unexpected (and hopefully funny) ways. Complete the program to read the needed values from input, that the existing output statement(s) can use to output a short story. Ex: If the input is: Eric Chipotle 12 cars

Answers

Answer:

statement = input("Enter four words separated by a space: ")

split_list = statement.split(" ")

print(f"{split_list[0]} went to {split_list[1]} to buy {split_list[2]} different types of {split_list[3]}")

Explanation:

The python program uses the input function to get user input from the STDIN and the words gotten are splitted to a list, then the items of the list are used as part of a sentence.

Answer:

Playing around with this and came up with this, it took about an hour before I understood what it was wanting.

first_name = input()

generic_location=input()

whole_number= input()

plural_noun= input()

print(first_name, 'went to', generic_location, 'to buy', whole_number, 'different types of', plural_noun)

Explanation:

I didnt understand it at first until I thought about it.  This would be the answer if you are looking for it.

If a machine cycle is 2 nanoseconds , how many machine cycles occur each second?

Answers

Answer: 5 × 10^8 cycles per second

Explanation:

First and foremost, we should note that 1 nanosecond = 1 × 10^-9 seconds

We are told that the machine cycle is 2 nanoseconds.

The number of machine cycles that occur each second will them be calculated as:

1 = 2 × 10^-9

= 5 × 10^8 cycles per second

The number of machine cycles that occur each second is 5 × 10^8 cycles per second.

Normalization works through a series of stages called normal forms. For most purposes in business database design, _____ stages are as high as you need to go in the normalization process.

a. two
b. three
c. four
d. five

Answers

I do believe it’s A.....

Normalization works through a series of stages called normal forms. For most purposes in business database design, three stages are as high as you need to go in the normalization process.

Normalization is the process of organizing and structuring a database in a way that reduces redundancy, dependency, and anomalies while improving data integrity and efficiency. It involves applying a set of rules and guidelines to design a database schema that minimizes data redundancy and ensures data consistency.

The primary goal of normalization is to eliminate data anomalies such as insertion, update, and deletion anomalies, which can occur when data is duplicated or dependencies between data elements are not properly managed.

Learn more about database on:

https://brainly.com/question/30163202

#SPJ6

Something I should look for when trying to decide if a source is credible is the publication's ....
1.pictures
2.date
3.popularity
4.front cover ​

Answers

Answer: Date

Explanation: We receive new information everyday, and things are always changing. If something is old, it may need to be updated with the correct information

. Write and execute a query that will determine the average age of customers broken out by the city in which they reside. Note: Make sure that the average age is not truncated to an integer.

Answers

Answer:

SELECT resid_city, avg(convert(float,age))

  FROM customer

 GROUP BY resid_city

Explanation:

SQL or structured query language is a language used to interact with databases. It is a relational database language, used to create, update, and query the content of databases.

The "SELECT" clause in the query statement above is used to read the content of the customer table querying the table based on the average age of customers grouped by their resident cities to return the "resid_city" and the float number of the average age.

Write a print10() method that takes an array as a parameter and prints out the first 10 words of the array.

Answers

Answer:

This question is answered using Java programming language:

public static void print10(String[]arr){

    for(int i =0; i<10;i++){

System.out.println(arr[i]);

    }

}

Explanation:

This line defines the method

public static void print10(String[]arr){

This iterates from 0 to 9 index of the array. In other words, 1st to 10th

    for(int i =0; i<10;i++){

This prints the required output (one on a line)

System.out.println(arr[i]);

    }

}

Refer to attachment for the complete program that includes the main method.

Following are the program to count array words:

Program Explanation:

Defining a class "Main".Inside the class, a method "print10" is declared that takes an array of string inside the parameter, and define a for loop that prints 10 string value.Outside the method, the main method is declared that defines the array of strings that holds string value and passes the value into the method "print10" and prints its value.

Program:

public class Main //defining a class Main

{

private static void print10(String[] di)//defining a method print10  

{

System.out.println("First 10 words in string array: ");//print message

for(int i=1; i<11; i++)//defining a loop that prints array value

{

System.out.println(i+"\t "+di[i]);//print array value

}

}  

public static void main(String[] a) //defining main method

{

String[] di = {"Alpha", "Bravo", "Charlie", "Delta", "Echo", "Foxtrot", "Golf", "Hotel", "India", "Julie", "Kilo", };//defining array of String that hold value

print10(di);//calling method and print its value

}

}

Output:

Please find the attached file.

Learn more:

brainly.com/question/7052857

Lola wants to install an add-in in Excel.She has to unblock the add-in to allow Excel to open the add-in file automatically.To do this,she right clicks on the add-in file and selects an option from the menu. What could the option be?
A) Copy
B) Delete
C) Rename
D) Properties

Answers

Answer:

The correct answer is:

Properties (D)

Explanation:

First of all, option D (Properties) is the option that makes the most sense in this scenario, because the other options: Copy, Delete, and Rename are unrelated commands to what is to be achieved.

Secondly and more practically, an add-in file may not load in excel, and most of the time it is blocked by default and has to be unblocked. The following steps are used:

1. close Excel if it is open

2. open the folder where the add-in file is located, right-click on the add-in file, and select "properties"

3. a display tray will appear, having the attributes: Read-only, Hidden, Advanced, and unblock. Click the checkbox against "unblock" and make sure it is checked.

4. click Apply and Click Ok

Voila, your add-in file is unblocked.

N:B The Images are for steps 2 and 3

//CODEvoid f(int a){while(a--) {static int n = 0;int x = 0;cout << "n: " << n++ << " ,x: " << x++ << endl;}}int main(){f(3);return 0;}Question: What is the output of the above code?

Answers

Answer:

The static n variable is incremented twice and the results printed in the console but the output of the x variable remains constant.

Explanation:

The while loop in the C++ source code increments the n variable as the argument of the function "a" is decremented. The n variable output is 0,1, and 2 while the x variable is 0 for every iteration.

5.14 Describe how the compare and swap() instruction can be used to provide mutual exclusion that satisfies the bounded-waiting requirement. (15 pts)

Answers

Answer:

Explained below

Explanation:

Compare and Swap(C&S) is simply an atomic operation whereby the compare and swap operations are automatically executed.

Now compare and Swap basically needs 3 arguments namely:

- 2 old values which we will label X and Y

- 1 new value which is written in X that we will call Z

Thus, we now have; C & S = {X, Y, Z}

To explain this well, let X be a variable where X has a value of 7.

Now, if a programmer gives a program me that X be multiplied by 2,then what C&S operation will do is;

I) Y = X where Y is a new variable.

II) Result = C&S(X, Y, X*7)

Variable X is global and this means that mere than one process and more than 1 thread can see the variable X.

Now, if a process named P1 wants multiply the variable X by 7 using C&S operation, it will first make a local copy of variable X (which in this case is now the new variable Y). After that it will atomically compare X & Y and if they are equal, it will replace X with 10X.

However, if they are not equal, P1 will re-read value of X into Y and carry of C&S instruction again.

A pedometer treats walking 2,000 steps as walking 1 mile. Write a program whose input is the number of steps, and whose output is the miles walked.
Output each floating-point value with two digits after the decimal point, which can be achieved as follows:
printf("%0.2lf", yourValue);
Ex: If the input is:
5345
the output is:
2.67
Your program must define and call a function:
double StepsToMiles(int userSteps)
#include
/* Define your function here */
int main(void) {
/* Type your code here. */
return 0;
}

Answers

Answer:

The complete program is:

#include <stdio.h>

double StepsToMiles(int userSteps){

   return userSteps/2000.00;

}

int main(void) {

   int userSteps;

   printf("User Steps: ");

   scanf("%d",&userSteps);

   printf("%0.2f", StepsToMiles(userSteps));

   return 0;

}

Explanation:

This line defines the function

double StepsToMiles(int userSteps){

This returns the required output by dividing userSteps by 2000.

We used 2000.00 because we want it to return a floating point number

   return userSteps/2000.00;

}

The main begins here

int main(void) {

This declares userSteps as integer

   int userSteps;

This prompt user for input

   printf("User Steps: ");

This gets user input

   scanf("%d",&userSteps);

This calls the function and also returns the required output to 2 decimal places

   printf("%0.2f", StepsToMiles(userSteps));

   return 0;

}

Answer:

Coral Language Code

A pedometer treats walking 2,000 steps as walking 1 mile. Define a function named StepsToMiles that takes an integer as a parameter, representing the number of steps, and returns a float that represents the number of miles walked. Then, write a main program that reads the number of steps as an input, calls function StepsToMiles() with the input as an argument, and outputs the miles walked.

Output the result with four digits after the decimal point, which can be achieved as follows:

Put result to output with 4 decimal places

If the input of the program is:

5345

the function returns and the output of the program is:

2.6725

Your program should define and call a function:

Function StepsToMiles(integer userSteps) returns float numMiles

Explanation:

Function StepsToMiles(integer userSteps) returns float numMiles

  numMiles = userSteps / 2000.0

 

Function Main() returns nothing

  float result

  integer userSteps

  userSteps = Get next input

  result = StepsToMiles(userSteps)

  Put result to output with 4 decimal places

Please could you help me
Task 4
Decode this:
010010010110011000100000011110010
110111101 10101001000000110001101
1000010110111000100000011110011​

Answers

Answer:

is this a among us reference oooorr...... im confused. are u being frfr ...?

Explanation:

Answer:

hmmmm its decode

Explanation:

decode

Define bit byte and word

Answers

Explanation:

Definitions. Bit = Binary digIT = 0 or 1. Byte = a sequence of 8 bits = 00000000, 00000001, ..., or 11111111. Word = a sequence of N bits where N = 16, 32, 64 depending on the compute

Write a Python3 program to check if 3 user entered points on the coordinate plane creates a triangle or not. Your program needs to repeat until the user decides to quit, and needs to deal with invalid inputs.

Answers

Answer:

tryagain = "Y"

while tryagain.upper() == "Y":

    x1 = int(input("x1: "))

    y1 = int(input("y1: "))

    x2 = int(input("x2: "))

    y2 = int(input("y2: "))

    x3 = int(input("x3: "))

    y3 = int(input("y3: "))

    area = abs(x1 *(y2 - y3) + x2 * (y1 - y3) + x3 * (y1 - y2))

    if area > 0:

         print("Inputs form a triangle")

    else:

         print("Inputs do not form a triangle")

    tryagain = input("Press Y/y to try again: ")

Explanation:

To do this we simply calculate the area of the triangle given that inputs are on plane coordinates i.e. (x,y).

If the area is greater than 0, then it's a triangle

If otherwise, then it's not a triangle.

This line initializes iterating variable tryagain to Y

tryagain = "Y"

while tryagain.upper() == "Y":

The following lines get the coordinates of the triangle

    x1 = int(input("x1: "))

    y1 = int(input("y1: "))

    x2 = int(input("x2: "))

    y2 = int(input("y2: "))

    x3 = int(input("x3: "))

    y3 = int(input("y3: "))

This calculates the area

    area = abs(x1 *(y2 - y3) + x2 * (y1 - y3) + x3 * (y1 - y2))

This checks for the condition stated above.

    if area > 0:

         print("Inputs form a triangle") This is printed, if true

    else:

         print("Inputs do not form a triangle") This is printed, if otherwise

    tryagain = input("Press Y/y to try again: ") This prompts the user to try again with another set of inputs

Assume you are part of the systems development team at a medium-sized organization. The database will enable sales reps to have more control over their customer information including up to date information on purchases, backorders, returns, and invoices. As a result of the system the company will be able to assign accounts to sales reps based on their expertise, the proximity to their other accounts, and experience level in the company. Commissions will also vary based on the types of products and services sold and the reps will be able to see special promotional programs in their regions. Part 1: you have just completed the database design portion of the systems design phase, and the project sponsor would like a status update. Assuming the project sponsor is a VP in the marketing department, with only a high-level understanding of technical subjects, how would you go about presenting the database design you have just completed? Part 2: how would your presentation approach change if the project sponsor were the manager of the database team?

Answers

This is my answer


2. Presenting to a non-technical manager should be much more high-level, with few if any technical details. The focus should be on how the database design will benefit the business (for example, with faster report generation). Presenting to a technical manager would be focused much more on the technical aspects of the database, with less of a focus on the business benefits of the design.

According to a survey of hikers on a trail, 50% of the hikers like Gatorade (G) and 40% like energy bars (E). 20% like both. Assume random selection:____________ a. Find the probability that a hiker likes Gatorade or energy bars b. If a hiker likes Gatorade, find the probability that he likes energy bars c. If a hiker likes energy bars, find the probability that he likes Gatorade.

Answers

Answer:

Explanation:

As per given data

Probability hikers like Gatorade (G) = P(G) = 50% = 0.5

Probability hikers like energy bars = P(E) = 40% = 0.4

Probability hikers like both = P(G and E) = 20% = 0.2

a)

To find the probability that a hiker likes Gatorade or energy bars use the following formula

P(G or E) = P(G) + P(E) - P(G and E )

P(G or E) = 0.5 + 0.4 - 0.2

P(G or E) = 0.7

b)

To find the probability that a hiker likes Gatorade or energy bars use the following formula

P(E|G) = P(E and G)/P(G)

P(E|G) = 0.2/0.5

P(E|G) = 0.4

c)

The probability that he likes Gatorade.

P(G|E) = P(G and E) / P(E)

P(G|E) = 0.2 / 0.4

P(G|E) = 0.5

Whats wrong with this code​

Answers

You're not adding your temperature to the total so total will always be 0. Do something like this:

total += float(input("Enter Temperature: "))

You can directly add the user entered value without creating an extra variable.

Visual Design includes 4 elements: shapes, texture, lines and form.

Question 6 options:
True
False

Answers

Answer:

Explanation:

The answer is false

Because the 4 elements are shapes texture colour and size

1. Write a high level algorithm for cooking a cheeseburger.

2. Write a detailed algorithm for cooking the same cheeseburger.

Answers

Answer:

1.  A high level algorithm for cooking a cheeseburger could be:

Heat fry panCook one side of the hamburgerWaitTurn hamburger upside downPut cheese over hamburgerWaitCut hamburger bread in halfPut cooked hamburger inside breadEnd (eat)

2. A detailed algorithm for cooking a cheeseburger could be:

Place fry pan over the stove heaterTurn on heater (max temp)IF fry pan not hot: wait, else continuePlace raw hamburger on fry panIF hamburger not half cooked: Wait X time then go to line 5, else continueTurn hamburger upside downPut N slices of cheese over hamburgerIF hamburger not fully cooked: Wait X time then go to line 8, else continueTurn off heaterCut hamburger bread in half horizontally Put cooked hamburger on one of the bread halves.Put second bread half on top of hamburgerEnd (eat)

Explanation:

An algorithm is simply a list of steps to perform a defined action.

On 1, we described the most relevant steps to cook a simple cheeseburger.

Then on point 2, the same steps were taken and expanded with more detailed steps and conditions required to continue executing the following steps.

In computational terms, we used pseudo-code for the algorithm, since this is a list of actions not specific to any programming language.

Also we can say this is a structured programming example due to the sequential nature of the cooking process.

Design a for loop that gets 6 integer numbers from a user, accumulates the total of them, then displays the accumulated total to the user. Just write the code segment to show what is asked, not a complete program. However, declare any variables that you need to use. Use a semicolon (;) at the end of each line of code so I can tell when you use a new line in your code.

Answers

Answer:

Explanation:

The following loop code is written in Java and asks the user for the 6 integer numbers as mentioned in the question and sums them up. Finally putting them into a variable named total and printing it out.

       int total = 0;

       for (int x = 0; x < 6; x++) {

           Scanner in = new Scanner(System.in);

           System.out.println("Enter an integer: ");

           total += in.nextInt();

       }

       System.out.println("Your total is: " + total);

Write a program that demonstrates the class by creating a Payroll object, then asking the user to enter the data for an employee.

Answers

Answer:

import java.util.Scanner;

public class Payroll {

   //set variable field

   private String name;

   private int idNumber;

   private double hourlyRate;

   private int hoursWorked;

   private double grossPay;

   //methods to get values of private class variables

   public String getName()

    {

        return name;

    }

   public int getIdNumber()

   {

      return idNumber;

   }

   public double getHourlyRate()

   {

       return hourlyRate;

   }

   public int getHoursWorked()

   {

       return hoursWorked;

   }

   public double getGrossPay()

   {

      return hoursWorked * hourlyRate;

   }

   //methods to initialize or change the private class values.

   public void setName( String nameGiven)

   {

       name = nameGiven;

   }

   public void setIdNumber(int idNumberGiven)

   {

       idNumber = idNumberGiven;

   }

   public void setHourlyRate(double rateGiven)

   {

       hourlyRate = rateGiven;

   }

   public void setHoursWorked(int hoursGiven)

   {

      hoursWorked = hoursGiven;

   }

   //Constructors

   public Payroll(String nameGiven, int idNumberGiven, double rateGiven, int hoursGiven)

   {

       name = nameGiven;

       idNumber = idNumberGiven;

       hourlyRate = rateGiven;

        hoursWorked = hoursGiven;

   }

 

   public static void main(String[] args)

   {

       double userGrossPay;

       String userEmplName;

       int userIdNum;

       double userRate;

       int userHours;

       Scanner scanner = new Scanner(System.in);

       System.out.print("Enter employee's name:");

       userEmplName = scanner.nextLine();

      System.out.print("Enter employee's ID number:");

       userIdNum = scanner.nextInt();

       System.out.print("Enter hourly rate:");

       userRate = scanner.nextDouble();

       System.out.print("Enter number of hours worked:");

       userHours = scanner.nextInt();

        Payroll payroll1 = new Payroll(userEmplName, userIdNum, userRate, userHours);

 

      payroll1.setName(userEmplName);

       payroll1.setIdNumber(userIdNum);

       payroll1.setHourlyRate(userRate);

       payroll1.setHoursWorked(userHours);

 

       System.out.printf(userEmplName + ", employee number " + userIdNum + ", made $%.2f in gross pay.\n", payroll1.getGrossPay());

}

}

Explanation:

The class "Payroll" is used to hold data of employees to be paid. the main function creates an instance of the class "payroll1", sets the name, id-number, hourly rate, and hours worked by the employee, then prints on screen the details of the payroll1 object.

If a system's instruction set consists of an 8-bit opcode, what is the maximum number of output signal lines required for the control unit?
A) 8 B) 64C) 128 D) 256

Answers

Answer:

D. 256

Explanation:

Given

[tex]Instructions = 8\ bit[/tex]

Required

Determine the maximum number of output

To get the required value, we make use of the following:

[tex]Maximum = 2^n[/tex]

Where n is the bits of the opcode.

i.e.

[tex]n = 8[/tex]

Substitute 8 for n in [tex]Maximum = 2^n[/tex]

[tex]Maximum = 2^8[/tex]

[tex]Maximum = 256[/tex]

Hence, option D answers the question

Computer Hardware and Maintenance
Question 1 of 5
A protocol for maintaining technology and supplies may answer
questions such as:
What is the replacement life for each piece of equipment?
All of these answers
What should supplies be ordered?
When will security updates and enhancements be applied?
Submit Ansv

Answers

Answer:

All of these answers

Explanation:

A computer's physical components must be inspected, updated, and maintained over time to keep them functioning at their best. This process is known as hardware maintenance. Thus, option B is correct.

What is the best way for hardware Maintenance?

Regular hardware maintenance typically aids companies in avoiding unforeseen problems like device damage and severe data loss.

Regular hardware repair of servers and other physical parts enables businesses to retain their operational integrity and keep a stable IT infrastructure.

While corrective maintenance entails replacing or repairing a system or its components after they have already failed, preventive maintenance encompasses actions that can be taken to keep the system operating.

Therefore, Preventive and corrective maintenance are the two key elements of system upkeep.

Learn more about Hardware here:

https://brainly.com/question/28146743

#SPJ2

Which of these usually runs in the background without much
interaction with the user?
A
systems software
B
application software
C
a GUI
D
input/output devices

Answers

Answer:

A:System Software is the answer

Display the order date and the ship date for all orders that were made April 1 through April 15. List the order date, ship date, order priority, and ship mode. Order the results by order_date. Do you notice anything unusual about the data? [Hint: You will need to join the orders and shipping together and use a join statement. You will need to limit the result set by the date field order_date <= to_date('04/15/2018', 'mm/dd/yyyy')This is what I was able to come up with but it still gave me an error.select orders.order_date, shipping.ship_date, orders.order_priority, shipping.ship_modefrom ordersinner join shipping on orders.order_date = shipping.ship_datewhere Orders.Order_date = Shipping.ship_date AND Order_Date BETWEEN TO_DATE (’04/01/2018’, ‘04/15/2018’)ORDER BY Order_Date;

Answers

Answer:

SELECT Order_date, Ship_Date, Order_priority, Ship_mode

FROM orders

JOIN Shipping ON Orders.Order_id = Shipping.Order_id

WHERE Order_date

BETWEEN TO_DATE('04/01/2018', '%m/%d/%Y') AND TO_DATE('04/15/2018', '%m/%d/%Y')

ORDER BY Order_date

Explanation:

The SQL statement above queries a database with four tables shipping, orders, market and product. The query returns four columns from two tables orders and shipping, returning only rows with order dates between April 1 and April 15 of 2018. The tables are joined with the primary key order_id and the dates are parsed with the to_date function. The result is also ordered by the order_date

Other Questions
On page 75 Ponyboy says, I relaxed. We could take whatever was coming now. Predict what you think is coming, from the outsiders What is the answer to 2x^2+9x-35 The volume of a cube is given by the formula V = s3, where s is the length of one side. What is the volume of the cube including the planet? First, justify your answer using the Product of Powers Property. Then justify your answer using the Power of a Product Property. Suzie scored 75% on her assignment. If she got 15 questions correct, how many total questions were on the assignment? The land revenue system that developed during the reign of Akbar was called____________.Immersive Reader (1 Point) a) Zabti b) Jagir c) Din-I-illahi d) Zat A biker begins to move from an initial speed of 0.0 m/sec to a final speed of 25 m/sec in 10 sec. what is the acceleration of the skater? Whats the slopePlease help What information should you use to draw conclusions?factseducated guessessummariesopinions In the short story "Eveline" by James Joyce, Eveline has planned to leave her father's home to marry her fianc and travel with him to South America. At the dock, preparing to board the steamer with her fianc, Eveline is distraught. What is the epiphany that Eveline experiences?"The boat blew a long mournful whistle into the mist. If she went, tomorrow she would be on the sea with Frank, steaming towards Buenos Ayres. Their passage had been booked. Could she still draw back after all he had done for her? Her distress awoke a nausea in her body and she kept moving her lips in silent fervent prayer.A bell clanged upon her heart. She felt him seize her hand:Come!All the seas of the world tumbled about her heart. He was drawing her into them: he would drown her. She gripped with both hands at the iron railing.Come!No! No! No! It was impossible. Her hands clutched the iron in frenzy. Amid the seas she sent a cry of anguish!Eveline! Evvy!He rushed beyond the barrier and called to her to follow. He was shouted at to go on but he still called to her. She set her white face to him, passive, like a helpless animal. Her eyes gave him no sign of love or farewell or recognition.Works CitedJoyce, James. ''Eveline.'' Dubliners. Grant Richards, Ltd., 1914.A)Her fianc no longer respects or values her.B)She cannot give up the certainty of home for the hope her fianc offers her.C)She does not have the courage to face her terror of dying at sea.D)She wants to stay in Ireland and be married. 11Which of the following effects can occur because of the high surface tension of water?A. Organisms can resist temperature changes, although they give off heat due to chemicalreactions| B. A raft spider can walk the surface of a small pondC. Sweat can evaporate from the skin, helping to keep people from overheatingD. Lakes cannot freeze solid in winter, despite low temperatures Were the Aztecs violent? Why or why not? IN YOUR OWN WORDS PLEASE Kadence reads 8 pages in her book every 30 minutes. How many pages will she read in 6 hours? If jim had 8 apples and you took 5 away and gave him two back how many apples do you have? 1. A basketball player made 12 out of 15 free throws she attempted. She wants to know how many consecutive free throws she would have to make to raise the percent of successful free throws to 85% (a) Write an equation to represent this situation. (b) Solve the equation. How many consecutive free throws would she have to make to raise her percent to 85%? Solve and simplify to simplest form: 1 3/8 (7/8) Pretty Pretty please helpWhen the personal pronouns, I, me, my, and we are used, the point of view is *Second-personFirst personThird-person limitedThird-person omniscient PLEASE ANSWER ASAP!!!!During the Revolutionary Period, which did James Grant accomplish ? Check all that apply.a)lead raids on patriot towns in Floridab)serve as a general in the British armyc)serve as the first governor of East Floridad)offer free land grants for settlemente)fight in the Siege of Pensacola where were most of the cities of the empire located i hate itits sooodum a 3.5 kg mass has an initial velocity of 4.0 m/s. How much force is required to increase the velocity of the mass to 8.0 m/s in 3.0 seconds?