1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Pani-rosa [81]
3 years ago
14

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;
Computers and Technology
1 answer:
Viktor [21]3 years ago
8 0

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

You might be interested in
Imagine that you need to prepare for three end-of-term tests. What steps will you take to make sure your study time is well spen
ziro4ka [17]

Answer:

I will also choose a good study area and copy them and paste it

4 0
2 years ago
Which structural semantic will this HTML code snippet form?
Yakvenalex [24]

Answer:

D. Block

Explanation:

Semantic HTML or semantic markup is HTML that introduces meaning to the web page rather than just presentation. For example, a <p> tag indicates that the enclosed text is a paragraph. This is both semantic and presentational because people know what paragraphs are, and browsers know how to display them.

3 0
3 years ago
What is the term for water wave that is created by an underwater earthquake
Mashutka [201]
A tsunami/tidal wave is a huge wave caused by an earthquake.
7 0
3 years ago
Which area of a magazine cover is often important for those shops and stalls that cannot display the entire cover page on a stan
zloy xaker [14]

I think the answer is one fourth.

Because usually only that part is visible in a stand. It usually contains the name of the magazine and a little bit of illustration gives an idea about what it is about.

6 0
3 years ago
Define a method calcPyramidVolume with double data type parameters baseLength, baseWidth, and pyramidHeight, that returns as a d
tamaranim1 [39]

The method calcPyramidVolume is an illustration of the java methods; where the methods are executed when called or evoked

<h3>The main program</h3>

The program written in Java, where comments are used to explain each action is as follows:

//This defines the calcPyramidVolume method

public static double calcPyramidVolume(double baseLength,double baseWidth, double pyramidHeight) {

//This calculates the volume of the pyramid

       double PyramidVolume = calcBaseArea(baseLength,baseWidth) * pyramidHeight;

//This returns the volume of the pyramid

       return PyramidVolume;

   }

Read more about java methods at:

brainly.com/question/19271625

7 0
3 years ago
Other questions:
  • Which of the following would allow for more data to be stored on a CD?
    11·2 answers
  • What kinds of online behaviors could be considered cyberbullying?
    7·2 answers
  • You can change the color of the value of a cell or the background color of the cell but not both.
    5·2 answers
  • When evaluating portable CD players, you consider price, the sound quality, and ease of using the controls. These are your _____
    8·2 answers
  • If you embed a Word table into PowerPoint, what happens when you make edits to the embedded data? A. Edits made to embedded data
    12·1 answer
  • How do you know where the home row of the keyboard is?
    14·2 answers
  • The first and second numbers in the Fibonacci sequence are both 1. After that, each subsequent number is the sum of the two prec
    6·1 answer
  • Ben is writing a paper for his college history class, and he wants to include some information he found on a Web site. What are
    5·1 answer
  • Please help me with these questions please
    15·1 answer
  • Plsssssssss help me​
    8·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!