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
kherson [118]
3 years ago
7

sing data from the BITS database, define a view named TopLevelClient. It consists of the number, name, address, balance, and cre

dit limit of all clients with credit limits that are greater than or equal to $10,000. Using SQL, write the view definition for TopLevelClient. Write an SQL query to retrieve the number and name of all clients as well as the difference between their credit limit and balance in the TopLevelClient view. Convert the query you wrote in Question 2b to the query that the DBMS will actually execute.
Computers and Technology
1 answer:
andreyandreev [35.5K]3 years ago
3 0

Answer:

a. CREATE VIEW TopLevelCust ASSELECT CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimitFROM CustomerWHERE CreditLimit >= 10000b. SELECT CustomerNum, CustomerNameFROM TopLevelCustWHERE Balance > CreditLimit;c. SELECT CustomerNum, CustomerNameFROM TopLevelCustWHERE CreditLimit >= 10000AND Balance > CreditLimit;

Explanation:

You might be interested in
. How does Word indicate a possible instances of inconsistent formatting?: *
REY [17]

Answer:b)With a wavy blue underline

Explanation:Wavy blue lines in the Word document is for representing that the Format consistency checker is in working/on mode .It can identify the inconsistent format instances for the correction while the user is writing the text.

Other options are incorrect because wavy red line is for incorrect spelling of any word and wavy green line signifies the grammatical mistake .The function is available for the format inconsistency as wavy blue line in Word .Thus, the correct option is option(b).

5 0
3 years ago
Alison is having a hard time at work because her Inbox is flooded with emails every day. Some of these emails are unsolicited. S
rosijanka [135]

Answer:

<u><em>(1) Spam, (2) Trash.</em></u>

Explanation:

"<u><em>Emails are unsolicited-" is another word for spam</em></u> lol. <u><em>And then "Others she doesn’t need." is, again, another word for trash</em></u>. I mean if you don't need it is trash then.

WELP I hope I helped you even tho this is late. Ahem, well. <u><em>Stay awesome!</em></u>

8 0
3 years ago
1.Computer Architecture and their examples . 2. what are the three system bus​
Aneli [31]

Answer:

WHAT IS  THIS QUESTION?

Explanation:

Please tell,e or I will

^45*7353_=+233

7 0
2 years ago
​identify a text-level element used to mark generic run of text within the document.
yaroslaw [1]

Multiple choices for the question above include;

<span>A)     </span>Mark

<span>B)      </span>Div

<span>C)      </span>Cite

<span>D)     </span>Span

Also known as the span tag, it is used to group inline-elements in a document by placing them in line or alongside other element content.

7 0
4 years ago
The checkout station for preparticipation physical evaluation (PPE) is critical because at this point:
Ray Of Light [21]
<span>The checkout station for preparticipation physical evaluation (PPE) is critical because at this point you would know your level of fitness and the contraindications on the activities that you can do. PPEs are an important tool to gauge how well you are doing physically so that you can gauge the level of fitness activity that you will get yourself involved in someday. If you have not done any PPE, you are risking yourself into getting unnecessary injuries.</span>
4 0
3 years ago
Read 2 more answers
Other questions:
  • Cleo received a message from Joline that was sent to her as well as two other coworkers named Sam and Thomas. Cleo
    6·2 answers
  • The Business Cycle rises and falls. The highest point of the Business Cycle is known as the __________.
    7·1 answer
  • 06.04 what's the big idea?
    15·1 answer
  • A pair is a simple struct with two data members, one of type T1 and one of type T2. A set and a map are organized as binary sear
    10·1 answer
  • Join zoom meet for time pass purpose <br><br>id=547 458 9345<br>pw=sencHURI​
    8·2 answers
  • What factors contribute to food wastage
    12·1 answer
  • E-mail played a role in political upheavals in Europe because it became an important means of communication in Europe. E-mail, c
    13·1 answer
  • 1) How can you set data types such as Number, currency and date in Ms- Excel? 2) Explain how values, text, data and time can be
    11·1 answer
  • What is collaboration
    14·1 answer
  • an attacker uses the nslookup interactive mode to locate information on a domain name service (dns). what command should they ty
    7·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!