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 1

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


Related Questions

Best of Luck
for your work and
d
Best wishes for you
.​

Answers

oh, why thank you same to you

Awwwww thank you
( please mark brainliest)

Identify a security context of interest to you. Within this context, what constitutes a direct benefit of a risk management strategy? An indirect benefit? Provide examples.

Answers

Here,the Preparedness of the National(National Preparedness), that which gives a description of mission areas and also provide a framework for the consideration of management of risk.

It gives an illustration of the relationship of the National preparedness mission elements of risk.

Activities aimed at prevention are also associated with the efforts for the addressing of protection efforts generally address vulnerabilities recovery efforts.

However,we see that efforts of mitigation transcends vulnerability and also consequence spectrum.

Here,the PPD-8 mission areas are central,and this is to enhance national preparedness and also for infrastructure risk management activities.

When these are developed,they contribute to the achievement of resilient and secure critical infrastructure,and these critical infrastructure risks are however seen as part of setting capability targets.

THREAT AND HAZARD IDENTIFICATION AND RISK ASSESSMENT.

"THIRA" gives a provision of an approach for the identification and assessment of risks and also the associated impacts.

Determination that THIRA process has been completed by jurisdiction,then you consider the results when undergoing the assessment of risks to critical infrastructure.

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

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.

Other Questions
which of these tables represents a linear function? How did the Battle of Salamis change the Persian Wars? O The Persians destroyed the Greek army at Salamis The battle was the first major battle of the Persian Wars. The Greeks surrendered after three days of fighting, and this ended the wars. The Greeks destroyed the Persian navy, and this was a turning point in the wars. The federal government creates the federal budget each year in order toPlease help and don't put a random answer. Multiple Choices is in the screen shot. 4x 3y = 11 8x + 2y = 46 PLEASE HURRY! After Dante catches the flu virus, he feels very tired and loses his appetite. His body aches and he gets a high fever. Which best describes Dantes symptoms? A) They are a response to an infection, which is an internal stimulus B) They are a response to being tired, which is an external stimulus ,C) They are a response to hunger, which is an internal stimulus D) They are a response to an illness, which is an external stimulus Explain why the exponent in 3.5 x 10 6 is 6 there are only 5 zeros in 3500000 Fowler, Inc., just paid a dividend of $2.55 per share on its stock. The dividends are expected to grow at a constant rate of 3.9 percent per year, indefinitely. If investors require a return of 10.4 percent on this stock, what is the current price "If you see me getting smaller, I'm leaving, don't be grieving, just gotta get away from here. If you see me getting smaller, don't worry, and no hurry, I've got the right to disappear." what do you think this quote mean? Which is the solution to the inequalit? 1/4 +x less than 5/6 THERE ARE 2 ANSWERS!!!!The economy is considered an important social institution because it directly facilitates which two of the following?A. supply of useful productsB. social reproductionC. secular cultureD. harmony in familiesE. profit and income 5/6 multiplied by 1/5Show you work please Harrison Bergeron is an exceptional fourteen-year-old boy because Laura is saving money to buy a bike. She has $52 and is going to save an additional $8 each week. The bike costs $164. In how manyweeks will she have enough money to buy the bike? ! Plz can any one help me plz ! From a handful of dates who does the author of the story portrays most sympathetically? I'm having trouble with this...Solve.{y=x63x+2y=8Use any method.(14, 8)(3, -3)(0, -6)(4, -2) How far does the foundation of the Socialist Party (1875) and Republican Party (1876) embody the discredit of the Monarchical regime? Nemos aquarium is filled with 2400 cm of water the base of the aquarium is 20 cm long and 12 cm wide what is the height of the water in Nemos aquarium 1. Tyler is organizing an extensive scientific research presentation on global warming for his professor. Which organizing triad would be the most appropriate?2. What is the best way to anticipate your audience's reaction when designing your message? True or False: Muslim rulers successfully converted all the people of East Africa to Islam Profit is defined as total revenue:__________ a. divided by total cost. b. times total cost. c. minus total cost. d. plus total cost.