Which of the following lists only the last four digits of the contact persons phone number at
Question:
Which of the following lists only the last four digits of the contact person’s phone number at American Publishing?
a. SELECT EXTRACT (phone, -4, 1)
FROM publisher
WHERE name = 'AMERICAN PUBLISHING';
b. SELECT SUBSTR (phone, -4, 1)
FROM publisher
WHERE name = 'AMERICAN PUBLISHING';
c. SELECT EXTRACT (phone, -1, 4)
FROM publisher
WHERE name = 'AMERICAN PUBLISHING';
d. SELECT SUBSTR (phone, -4, 4)
FROM publisher
WHERE name = 'AMERICAN PUBLISHING';
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 75% (4 reviews)
d SELECT SUBSTR ...View the full answer
Answered By
JAPHETH KOGEI
Hi there. I'm here to assist you to score the highest marks on your assignments and homework. My areas of specialisation are:
Auditing, Financial Accounting, Macroeconomics, Monetary-economics, Business-administration, Advanced-accounting, Corporate Finance, Professional-accounting-ethics, Corporate governance, Financial-risk-analysis, Financial-budgeting, Corporate-social-responsibility, Statistics, Business management, logic, Critical thinking,
So, I look forward to helping you solve your academic problem.
I enjoy teaching and tutoring university and high school students. During my free time, I also read books on motivation, leadership, comedy, emotional intelligence, critical thinking, nature, human nature, innovation, persuasion, performance, negotiations, goals, power, time management, wealth, debates, sales, and finance. Additionally, I am a panellist on an FM radio program on Sunday mornings where we discuss current affairs.
I travel three times a year either to the USA, Europe and around Africa.
As a university student in the USA, I enjoyed interacting with people from different cultures and ethnic groups. Together with friends, we travelled widely in the USA and in Europe (UK, France, Denmark, Germany, Turkey, etc).
So, I look forward to tutoring you. I believe that it will be exciting to meet them.
3.00+
2+ Reviews
10+ Question Solved
Related Book For
Question Posted:
Students also viewed these Computer science questions
-
Which of the following lists all books published before June 2, 2004 and all books published by Publisher 4 or in the Fitness category? a. SELECT * FROM books WHERE category = 'FITNESS' OR pubid = 4...
-
Which of the following lists all books published by the publisher named Printing Is Us? a. SELECT title FROM books NATURAL JOIN publisher WHERE name = 'PRINTING IS US'; b. SELECT title FROM books,...
-
Which of the following lists each book having a profit of at least $10.00 in descending order by profit? a. SELECT * FROM books WHERE profit => 10.00 ORDER BY "Profit" desc; b. SELECT title,...
-
List all types of bonding present in the compound CaCO3. List all types of bonding present in the compound CaCO3. I. ionic bond II. polar covalent bond III. nonpolar covalent bond A. I only B. II...
-
In March, current year, Mary Tone organized a corporation to provide package delivery services. The company, called Tone Deliveries, Inc., began operations immediately. Transactions during the month...
-
Accounting professionals that work for private companies often obtain the Certified Management Accountant (CMA) designation to indicate their proficiency in several business areas in addition to...
-
The General Social Survey asked 1373 men and 993 women in the United States whether they agreed that they were generally optimistic about the future. The results are presented in the following table....
-
How long does it take for the following to happen? a. $856 grows into $1,122 at 7% b. $450 grows into $725.50 at 12% compounded monthly c. $5,000 grows into $6,724.44 at 10% compounded quarterly
-
( b ) Seven years after a contractor had completed and handed over an office block, defects were discovered. The employer moved out into rented offices whilst the defects were being repaired. The...
-
Both Novador and Sashimia are members of the WTO. Sashimia is also one of 12 fishing nations that are members of the Southern Atlantic Tuna Fishing Organization (SATFO). SATFO was established in 1998...
-
Which of the following is not a valid format argument for displaying the current time? a. 'HH:MM:SS' b. 'HH24:SS' c. 'HH12:MI:SS' d. All of the above are valid.
-
Another name for the counting numbers is the numbers. Fill in the blank with an appropriate word, phrase, or symbol(s).
-
When Cyclohexanone is heated in the presence of a large amount of acetone cyanohydrin and a small amount of base, Cyclohexanone cyanohydrin and acetone arc formed. Propose amechanism. HO CN OH "OH +...
-
cars using the explanatory variables current mileage (Mileage) and year of manufacture (Year). a. Do you think that Year and Mileage are positively or negatively correlated? Explain. b. For a fixed...
-
The Pure Laines association organized in August 2019, Solo, a town located in the center of Kamrand, a march commemorating the memory of Von Boeggels, a powerful leader of a totalitarian regime that...
-
Website Evaluation Go to a Website that you often visit (mobile or desktop). ex. (Amazon) What is the first thing you notice when you load up the website? How accessible is the website? Does the...
-
You are a new-products consultant hired by Yummy, Inc., to provide guidance on a new vitamin-and-caffeine-enriched sports drink. In particular, you are to advice the company on both the naming and...
-
On January 1, 2024, a company adopted the dollar-value LIFO method. The inventory value for its one inventory pool on this date was $400,000. Inventory data for 2024 through 2026 are as follows: Date...
-
How does a sterilized central bank intervention affect the demand curve and the supply curve for a countrys currency?
-
Use the graphs of f and g to graph h(x) = (f + g) (x). To print an enlarged copy of the graph, go to MathGraphs.com. 1. 2. y 24 8. 2. -2 -2 4 6
-
Find a 77-bit one-time pad that generates the text Hello World from the cipher text of Fig. 8-4. Figure 8-4 Message 1: Pad 1: Ciphertext: 1001001 0100000 1101100 1101111 1110110 1100101 0100000...
-
Alice used a transposition cipher to encrypt her messages to Bob. For added security, she encrypted the transposition cipher key using a substitution cipher, and kept the encrypted cipher in her...
-
An affine cipher is a version of a mono-alphabetic substitution cipher, in which the letters of an alphabet of size m are first map to the integers in the range 0 to m-1. Subsequently, the integer...
-
Grouper Corporation was organized on January 1, 2022. It is authorized to issue 15,000 shares of 8%, $100 par value preferred stock, and 549,000 shares of no-par common stock with a stated value of...
-
what is teamwork ? why is it important ? what intrigued you the most about teamwork ? Share your understanding of Workflow Design and Teamwork Share your PERSONAL experience with Workflow Design and...
-
Consider the following function. # 1. Factor out the GCF. f(x)=x-x-4x+4x Hint: The answer should look similar to the following. f(x)=?(?-?-?+?) # 2. From the correct answer of # 1, factor out the GCF...
Study smarter with the SolutionInn App