Create a query that shows columns employee last name, job title and hire date for those employees who joined the company on or after the first day of December 2016. Do not display job title of stock clerk. Show records in descending order by job title (Z to A).

Answers

Answer 1

Answer:

SELECT last_name, job_title, hire_date FROM employee WHERE hire_date>="01-12-2016" AND job_title != "STOCK CLERK" ORDER BY job_title DESC;

Explanation:

The SQL code queries the employee table returning records of the last_name, job_title, and hire_date columns matching the employees hired on or after December 2016 and job titles that are not stock clerks in the employee table.

The WHERE and AND clause is responsible for the condition while the ORDER BY clause returns the query result in the of the job title in descending order.


Related Questions

What framework uses CSS to access and manipulate HTML elements?

____ uses CSS to access and manipulate HTML elements

Answers

Answer:

The correct answer is JQuery

Explanation:

JQuery uses CSS to access and manipulate HTML elements.

Answer:

the answer is:

JQuery

A. Write a class that declares a variable named inches that holds a length in inches,
and assign a value. Display the value in feet and inches; for example, 86 inches
becomes 7 feet and 2 inches. Be sure to use a named constant where appropriate.
Save the class as InchesToFeet.java.
B. Write an interactive version of the InchesToFeet class that accepts the inches
value from a user. Save the class as InchesToFeetInteractive.java.

Answers

Answer:

A.

public class Main{

public static void main(String[] args) {

 final int divisor = 12;

 int inches = 86 ,feet;

 feet =inches/divisor;

 inches = inches%divisor;

 System.out.print(feet+" feets "+inches+" inches");

}

}

B.

import java.util.*;

public class InchesToFeetInteractive{

public static void main(String[] args) {

 Scanner input = new Scanner(System.in);

 final int divisor = 12;

 int inches,feet;

 System.out.print("Measurement in Inches: ");

 inches = input.nextInt();

 feet =inches/divisor;

 inches = inches%divisor;

 System.out.print(feet+" feets "+inches+" inches");

}

}

Explanation:

Both classes use the same algorithm; however, the slight difference is that

(A) assumes a values of inch measure while (B) prompts user for input

That is show in the differences below

A)

int inches = 86 ,feet; ---> This initializes inches to 86;

B)

This prompts user for measurement in Inches

 System.out.print("Measurement in Inches: ");

This gets the measurement

 inches = input.nextInt();

The next lines are common in both classes

This declares and initializes a constant which is used in the conversion

 final int divisor = 12;

This calculates the number of feet in the user input

 feet =inches/divisor;

This gets the remainder inches, if any. It uses % to calculate the remainder

 inches = inches%divisor;

This prints the required output

 System.out.print(feet+" feets "+inches+" inches");

Write a statement that takes a variable named open_file that contains a file object and reads the next 12 characters into a variable named description.

Answers

Answer:

description=open_file.read(12)

Explanation:

A programming language in computer is a set formal languages that comprises a set of instruction which produce various kinds of output. It is used ti implement algorithms in computer programming.

In the context,  description=open_file.read(12) is the statement given to the computer as input which takes a variable named as open_file containing a file object and which reads the next 12 characters into the variable named as description.

Select the correct text in the passage.

Which statement in the paragraph indicates that a data storage problem exists with an enterprise system?

[Once implemented, enterprise systems have a lifespan of 10 to 20 years. After that, organizations can upgrade them or scale them up.] Although this seems like a long time, [data within organizations accumulates exponentially and may be too difficult to manage and store on a single software system.] [Data overflow and a subsequent slowdown in one department will have a ripple effect on other functions of an organization. ]This affects the performance of the entire system.

Answers

its C, sorry if im wrong but im pretty sure.

Explanation:

Answer:data within organizations accumulates exponentially and may be too difficult to manage and store on a single software system.

Explanation:

Clay wants to print T-shirts and sell them online. What printing press would be the best for him to use?

Answers

Answer:

I think is screen printing press.

Explanation:

Screen printing requires you to go through a multi-step, back-breaking process to print your t-shirt.

The binary constraint must cover indicates that ________.
A)a specific binary relationship must be included in a ternary relationship
B)a binary relationship includes a set of value combinations that must all occur in a ternary relationship
C)a table includes values that must occur in a binary relationship
D)a table includes values that must occur in a ternary relationship

Answers

Answer:

B

Explanation:

binary relationship includes a set of value combinations that must all occur in a ternary relationship

The array elements are always stored in__________memory locations. Write the word consecutive or random in the blank appropriately.

Answers

Answer:

contiguous.

Explanation:

An array can be defined as a set of memory locations (data structure) that comprises of a group of elements with each memory location sharing the same name. Therefore, the elements contained in array are all of the same data type e.g strings or integers.

Basically, in computer programming, arrays are typically used by software developers to organize data, in order to search or sort them.

Binary search is an efficient algorithm used to find an item from a sorted list of items by using the run-time complexity of Ο(log n), where n is total number of elements.

Binary search applies the principles of divide and conquer.

In order to do a binary search on an array, the array must first be sorted in an ascending order.

The array elements are always stored in contiguous memory locations.

It should be be noted that the array elements are always stored in contiguous memory locations.

According to the question, we are to discuss the array elements and how they are been always stored  .

As a result if this we can see that array elements are always stored in contiguous memory locations so as to enable the retrieval of the information.

Therefore, array elements are always stored in contiguous memory locations.

Learn More about array elements at;

https://brainly.com/question/3735128

To create an SSL connection, a Web server requires a ________, which is an electronic document that confirms the identity of a website or server and verifies that a public key belongs to a trustworthy individual or company.

a. DSL Degree
b. SSL Degree
c. SSL Certificate
d. DSL Certificate

Answers

Answer:

c. SSL Certificate

Explanation:

The full form of SSL is Secure Sockets Layer. It is the standard security technology which establishes the encrypted link between a client and the server—typically a web server (which is the website) and the browser, or the mail server along with a mail client (for e.g., Outlook).

In the context, in order to develop an SSL connection, an SSL Certificate is required by the Web server.

help ma??!! please please

Answers

hey what do you need help with?

give us a picture and we will try to help.

A network technician has made a UTP cable that is terminated as T586A on one end and T586B on the opposite end. What type of cable has been constructed?

Answers

Answer:

CROSSOVER CABLE

Explanation:

Crossover Cable is used to connect same types of device.

Crossover Cable is very similar to straight-through, except that they have pair of

wires that crisscross. This allows the two devices to communicate at the same

time.

TIA/EIA 568A: White/Green-Green, White/Orange-Blue, White/Blue-Orange,

White/Brown-Brown

TIA/EIA 568B: White/Orange-Orange, White/Green-Blue, White/Blue-Green,

White/Brown-Brown

Some programmers include scroll bars, title bars, buttons, and menus in a program simply by adding them to a layout through a process called ______________ programming.

Answers

Answer:

Visual.

Explanation:

Some programmers include scroll bars, title bars, buttons, and menus in a program simply by adding them to a layout through a process called visual programming.

A visual programming language is also commonly referred to as graphics user interface builder (GUI builder) and can be defined as a programming tool that avails programmers the ability to develop software programs (applications) using graphical elements and figures rather than texts alone.

Some examples of visual programming language are executable UML, Blockly, Kodu, Alice, Lego mindstorms, Gamemakers etc.

Two of the most popular web servers are Apache and Microsoft IIS. Discuss some of the tools and techniques used to secure these web servers.

Answers

Answer:

Answered below

Explanation:

Various tools and techniques are used to secure web servers and they include;

- Network firewalls which are systems used to prevent unauthorized access to a server from external networks.

- Antiphishing tools used to prevent phishing.

- Encryption tools which use cryptography to encode sensitive data.

- Penetration testing softwares are used to test the vulnerability of network security.

- Antivirus softwares.

Which button in the Sort & Filter gallery of the Data tab would alphabetize from A to Z quickly?
Sort
AZ down arrow
AZ up arrow
Filter

Answers

Answer:

B AZ down arrow

Explanation:

got it right

Answer:

B. AZ down arrow

Explanation:

I'ts right on Edge

Have a good day!!!

Which button in the Sort & Filter gallery of the Data tab would alphabetize from A to Z quickly?

Answers

Answer:

the answer is B (AZ down arrow)

Explanation:

why do we need the system requirements for Adobe photoshop?

Answers

I’m sorry and I do not know I just need credits thank have a nice day

Explain the three schemes via which the binding of instructions and data to memory addresses can be done. In each scheme, how the logical address can be converted to physical address?

Answers

Answer:

Compile time

Load time

Execution time

Explanation:

The binding of instructions can be done in three steps, which are:

Compile time

Load time

Execution time

• Compile time In compile time, absolute code is usually generated when the compile time where the process resides in the memory is known

• Load time - in contrary to compile time, if it is not known at compile time where the process will reside in memory, then the compiler has to generate a relocatable code. In this scenario, the final binding is usually delayed until load time.

• Execution time - if the process is able to be moved during its execution from a particular memory segment to another segment, then binding is delayed until run time.

1. Which of the following does NOT have Artificial Intelligence?

Siri/Alexa
driverless cars
Wireless Speakers
Face Recognition​

Answers

None of the above I think it is Siri I am sorry if it is a wrong

Answer:

wireless speakers

Explanation:

siri is a spin-off from a project originally developed by the SRI International Artificial Intelligence Center. Its speech recognition engine was provided by Nuance Communications, and Siri uses advanced machine learning technologies to function. alexa is the same. driverless cars when talking about autonomous cars, it is almost impossible not to discuss artificial intelligence. AI is used to enable the cars to navigate through the traffic and handle complex situations. Also, with a combined AI software and other Iot sensors, such as cameras, it becomes easier to ensure proper and safe driving.face recognition and AI can be discussed as different mechanisms and I do so occasionally to make clear that they are intertwined it is important to note that most any contemporary, powerful face recognition has certainly been developed using some aspect of AI so as it is clearly wireless speakers.

Protected members of a base class are like ________, but they may be accessed by derived classes. a. constructor functions.b. static members.c. private members.d. public members e. none of these.

Answers

Answer:

C). private members

Explanation:

These are options

a. constructor functions

b. static members

c. private members

d. public members

Protected members can be regarded as member that accessibility of them from outside the class is zero, they can only get accessibility from derived classes, though this is not applicable to private class. It should be noted that Protected members of a base class are like private but they may be accessed by derived classes.

Jacob has a text file open, and he is typing on the keyboard. What is the best description of how the
changes are being implemented?
O The original file is temporarily changed; the changes become permanent when he clicks "save."
O The new version is kept in a special virtual space; the file is only changed when he clicks "save."
O The information is stored on the clipboard.
O A copy is created with a new filename, which will overwrite the old one when he clicks "save."

Answers

Answer:

The new version is kept in a special virtual space; the file is only changed when he clicks “save.”

Explanation:

I took the test and got it correct.

The best description of how the changes are being implemented is the new version is kept in a special virtual space; the file is only changed when he clicks "save." The correct option is b.

What is a keyboard?

Using a keyboard, you can input letters, words, and numbers into your computer. When you type, you press each key on the keyboard separately.

On the right side of the keyboard, you can also find the number keys that run across the top of the keyboard. The principal use of a keyboard is as an input device.

A person can type a document, use keystroke shortcuts, access menus, play games, and complete a number of other tasks with a keyboard.

Therefore, the correct option is b, The new version is kept in a special virtual space; the file is only changed when he clicks "save."

To learn more about keyboards, refer to the below link:

https://brainly.com/question/24921064

#SPJ2

who here has a crush on jk from bts but feels more mature than him

Answers

Answer:

Nope not K-pop fan

Explanation:

Suppose datagrams are limited to 1,500 bytes (including header) between source Host Aand destination Host B. Assuming a 20-byte IPheader, how many datagrams would be required to send an MP3 consisting of 5 million bytes? Explain how you computed your answer.

Answers

Answer:

3424 datagrams would be required

Explanation:

Mp3 file size = 5 million bytes

assuming the data is carried in TCP segments with each TCP segment have 20 bytes of header

Therefore each datagram can carry at least : ( 1500 - 40 ) = 1460 bytes

Therefore the number of datagrams required = [tex][\frac{5*10^6}{1460} ][/tex]    =  3424

The MP3 file to be transmitted does have a size of 5 million bytes or [tex]5 \times 10^6\ \ bytes[/tex]. Suppose that information is moved via TCP segments with a TCP header size of 20 bytes.

Each IP header is 20 bytes long, and the TCP header is also 20 bytes long. Therefore, we use 40 bytes out of a total of 1500 bytes for IP and TCP headers. Then, in each datagram, we can send [tex]1500-40 = 1460[/tex] bytes of MP3 files. So, overall number of data packets necessary:

         [tex]= \frac{\text{Total MP3 Size}}{\text{ MP3 Size}}[/tex]

calculating the each datagram that is capable of transporting:

                 [tex]\to \frac{5000000}{ 1460} \\\\ \to 3424.65753425 \\\\\to 3425 \ \ Datagrams.[/tex]

Except for the last one, all datagrams would be 1500 bytes in size. Your final datagram will be 1000 bytes long, i.e,

   [tex]\to 1460 \times 0.65753425 \\\\ \to 960 + 40 \ \text{(Bytes of Header)} \\\\ \to 1000 \ Bytes\\[/tex]

Learn more:

brainly.com/question/16666220

education is better than money give point​

Answers

Answer:

yes education is better than money

Explanation:

money isn't everything

Your classmate constructs a simple computer that adds numbers. There are 5 wires for inputting the first
number, and the wires are currently "on","on", "off, "on", "off", or 11010 in binary.
What decimal number does that represent?

Answers

Answer:

26

Explanation:

Which of these is NOT a benefit of being connected 24/7?
A. You can find information using search engines.
B. You can use weather apps to help plan outdoor activities.
C. You can feel like you have to respond to a message right away, even if you don’t want to.
D. You can use music apps to create, share, and listen to playlists.

Answers

Answer:

c

Explanation:

answering messages is a more of a choice than a benifit.

this is my pc it had glowing rams but we changed them​

Answers

Answer:

nice how many fps

Explanation:

wow very nice I love it I think it looks great

Program that take 3 number and display them in ascending order c++

Answers

Answer:

#include <iostream>     // std::cout

#include <algorithm>    // std::sort

#include <vector>       // std::vector

using namespace std;

int main()

{

   vector<int> myvector{ 8, 1, 3 };

   std::sort(myvector.begin(), myvector.end());

   for (int x : myvector)

       cout << x << " ";

}

Explanation:

Use STL libraries where you can to keep your code robust!

Why is it important to turn your work in on time? How does submitting your work on time demonstrate academic integrity? How do you plan to ensure your academic success by turning your work in on time?

Answers

Answer:

It is important to turn the work on time for two fundamental reasons: first, because it allows the student to organize their time more efficiently, without delays in his presentations; and second, because it shows the responsibility of the student in front of his obligations, which gives a positive concept in front of teachers and managers.

In addition, the delivery of work in a timely manner is a clear sample of academic integrity: it shows that the student has his academic career as his main priority, over other alternatives such as work or leisure. That is, it realizes that the student is applied and integral when considering his academic responsibilities.

In my case, I seek to ensure my academic success by submitting my work in advance, which gives me time to receive corrections from the teachers and to be able to modify my mistakes.

Why should you try to contact the technical support staff of a web hosting provider before you become one of its customers?

Answers

Answer: Contacting technical support can give you a general idea of the responsiveness of the web host provider to issues and problems. If the technical support staff is slow getting back to you at this point, don't be surprised if you get the same type of service when you have a problem and need immediate help. While not fail-safe, a quick response to a simple question at least gives the appearance of a well-organized, professional, and responsive technical support staff.

Provide an example where a company has demonetized a market or industry.

Answers

Companies are shut down if copyrighted

please tell fast plzzzzzz​

Answers

Answer:

heyyy

your answer is false

HOPE IT HELPS YOU OUT PLEASE MARK IT AS BRAINLIEST AND FOLLOW ME PROMISE YOU TO FOLLOW BACK ON BRAINLY.IN

Answer:

false..................

Other Questions
Did Pilar bring her lunch to school?abstract nounconcrete nounpronoun Find two current events/debates from two different publications that are new to you. Write a one-paragraph reaction about each publication's perspective on both issues. How does fractional reserve banking grow the economy?A. By making it possible for foreign currency to be converted intonew U.S. dollarsB. By allowing the same money to be both stored as a deposit andloaned to businessesC. By forcing a bank to maintain a reserve that covers all depositsmade to itD. By giving banks the authority to print their own money during aneconomic emergency How did horizontal integration limit competition? ANSWER RIGHT AWAY!!! DUE IN 15!!! Consider the function h(x)=1/2x-3 with a restricted domain of {-2,0,2,10}. What is the range of the function? Describe techniques companies may use to enter or grow markets in other countries. Evaluate the benefits and pitfalls of several of these tactics. What reasons can you give for excluding from jury service members of theclergy, attorneys, physicians, police officers, and convicted felons? Shouldeveryone be required to serve on juries? Give your reasons. PLEASSSSEEEE NEED HELP FAST An object weighs 3 lb. at 10 earth radii from its center. What is the object's weight on the earth's surface?______ lb.3003033,000 Which approach toward parenting does the old saying, "Children should be seen and not heard," reflect?permissiveauthoritativeauthoritarianneglectful Was the colonial attempt to seize canda a success? Guess the carHint**Uncommon?** Identify the cultural traits that belong to Brazil, Italy, or both. pasta passion for soccer samba dance Portuguese Roman Catholicism 2:3 is equivalent to 4:7? True or False? Thanks :) Reflect B(2, 2) over the y-axis. In 1775, the British marched on Lexington and Concord todo what? Please help me I dont know it find the amount of x. 2x+4=3x-10 What are the three kinds of map projections What is a non-example of biodiversity?