Question

For sqlite: Write a single SQL statement to list all the tracks that do not have...

For sqlite: Write a single SQL statement to list all the tracks that do not have the exact word 'time' (including both upper and lower cases) as part of the name in the Track table, but they have 'time' being part of a word in the name. For instance, it should include track names with words like 'wartime' or 'times' in the output I have to find a way to limit the exact word but the word should be part of a word. For example, 'Time' is not okay, but 'Sometimes' is acceptable.

Homework Answers

Answer #1

You can achieve this using the UPPER() function to exclude exact word Time in insensitive cases and LIKE to include words having time as a part of it.

  • SELECT name
  • FROM Track
  • WHERE UPPER(name) <> 'TIME' and UPPER(name) LIKE UPPER('time%') ;

Note that this will include all cases of subpart Time in the word, eg SomeTime, sometimes, someTiMEs all will be accepted. If you want to include only 'time' as a subpart then the second condition in the where clause will have no UPPER() just use name like 'time%'

i.e,

  • WHERE UPPER(name) <> 'TIME' and name LIKE 'time%'
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
**please write code with function definition taking in input and use given variable names** for e.g....
**please write code with function definition taking in input and use given variable names** for e.g. List matchNames(List inputNames, List secRecords) Java or Python Please Note:    * The function is expected to return a STRING_ARRAY.      * The function accepts following parameters:      *  1. STRING_ARRAY inputNames      *  2. STRING_ARRAY secRecords      */ Problem Statement Introduction Imagine you are helping the Security Exchange Commission (SEC) respond to anonymous tips. One of the biggest problems the team faces is handling the transcription of the companies reported...
Summary The Ch08_ConstructCo database stores data for a consulting company that tracks all charges to projects....
Summary The Ch08_ConstructCo database stores data for a consulting company that tracks all charges to projects. The charges are based on the hours each employee works on each project. The structure and contents of the Ch08_ConstructCo database are shown in Figure P8.1. Use this database to answer the following problems. Database Schema The schema for the Ch08_ConstructCo database is shown below and should be used to answer the next several problems. Click this image to view it in its own...
Homework 3 Before attempting this project, be sure you have completed all of the reading assignments,...
Homework 3 Before attempting this project, be sure you have completed all of the reading assignments, hands-on labs, discussions, and assignments to date. Create a Java class named HeadPhone to represent a headphone set. The class contains:  Three constants named LOW, MEDIUM and HIGH with values of 1, 2 and 3 to denote the headphone volume.  A private int data field named volume that specifies the volume of the headphone. The default volume is MEDIUM.  A private...
Florida Now Real Estate (45 pts) Tanya Pierce, President and owner of Florida Now Real Estate...
Florida Now Real Estate (45 pts) Tanya Pierce, President and owner of Florida Now Real Estate is seeking your assistance in designing a database for her business. One of her employees has experience in developing and implementing Access-based systems, but has no experience in conceptual or logical data modeling. So, at this point Tanya only wants you to develop a conceptual data model for her system. You are to use our entity-data diagramming notation - Crows foot symbols. Tanya has...
Q1. Use Union statements to show the following: list the number of artists that have a...
Q1. Use Union statements to show the following: list the number of artists that have a webaddress, the number of artists that do not have a webaddress, and the total number of artists. The output should look like: +--------------------------+----------+ | Has webaddress | count(*) | +--------------------------+----------+ | Has webaddress | 5 | | Does not have webaddress | 6 | | Total | 11 | +--------------------------+----------+ Q2. A new salesperson has been hired. Their SalesID is 5, full name is...
After listening to this podcast, list and discuss the safe injection practices you should follow to...
After listening to this podcast, list and discuss the safe injection practices you should follow to prevent causing harm. Protecting Patients from Unsafe Injections: What Every Provider Needs to Know [Announcer] This program is presented by the Centers for Disease Control and Prevention. [Joyanna Wendt] Hello. I’m Dr. Joyanna Wendt, a Medical Officer at the Centers for Disease Control and Prevention, or CDC, and today we’re talking about injection safety. I know some of you are thinking, “That’s so basic....
Use Python 3.8: Problem Description Many recipes tend to be rather small, producing the fewest number...
Use Python 3.8: Problem Description Many recipes tend to be rather small, producing the fewest number of servings that are really possible with the included ingredients. Sometimes one will want to be able to scale those recipes upwards for serving larger groups. This program's task is to determine how much of each ingredient in a recipe will be required for a target party size. The first inputs to the program will be the recipe itself. Here is an example recipe...
Write a Python 3 program called “parse.py” using the template for a Python program that we...
Write a Python 3 program called “parse.py” using the template for a Python program that we covered in this module. Note: Use this mod7.txt input file. Name your output file “output.txt”. Build your program using a main function and at least one other function. Give your input and output file names as command line arguments. Your program will read the input file, and will output the following information to the output file as well as printing it to the screen:...
Explain the complete HAZOP procedure as followed in the industry. See summary below. Explain all the...
Explain the complete HAZOP procedure as followed in the industry. See summary below. Explain all the main parts of HAZOP study in details given in the Pdf file including: 1. Overview (including definitions and usage) 2. Hazop methodology (including phases like definition, preparation, examination, documentation and follow-up). Give examples also 3. Risk review 4. Risk communication Guidance: Study the procedure carefully and then write the answers in your own words. Hazard & Operability Analysis (HAZOP) 1   Overview: Hazard and Operability...
I'm working in a 6 page research paper and below is the complete list of the...
I'm working in a 6 page research paper and below is the complete list of the paper has to be set up and the required things needed to be included. Can you check to see what is already included on the list and what is missing in my paper. Also, what I need to improve and how? My topic is "The Struggles of Epilepsy". Can you help me with the content (background, empirical research, and hypothesis )? I also need...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT