I need help to add some queries to finish my

I need help to add some  queries to finish my project 

 

Part 2

Create a query that shows the following information: you should have 8 queries and 2 tables in your access database. 

8 queries needed

  1. How many and which boats can seat more than 9 people
    1. Identify boat id, boat type
  2. How many and which boats can sleep more than 5 people
    1. Identify boat id boat type and ……..
  3. Which boats are older than 15 years
    1. Identify fields to display
  4. How many provide the cheapest boat to rent per day
    1. Identify boat id boat type and cost
  5. how many provide the most expense boats to rent per day
    1. Identify boat id boat type and cost
  6. Which is the biggest boat?
  7. Which is the smallest boat?
  8. Which is the oldest boat?

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Develop a long-term and a short-term plan for yourself using

Develop a long-term and a short-term plan for yourself using what you have learned about yourself through the SWOT analysis and environmental scan you completed. Introduction Note: Developing a strategic plan requires specific steps that need to be executed in a sequence. The assessments in this course are presented in

250 words Watch the “Supply Chain Design at Crayola” video

250 words   Watch the “Supply Chain Design at Crayola” video (http://mediaplayer.pearsoncmg.com/assets/LnIIHC9aR9HSbSghd1Gjz4c_MgoLAzyD). Review the “Supply Chain Design at Crayola” video case on page 505. Respond with answers to the questions using your critical thinking and moral reasoning skills.  If you are asked to draw an illustrative figure such as a

For this worksheet task, due in Module Four, you will

 For this worksheet task, due in Module Four, you will identify a gap in social psychology research and begin to develop a basic research question to address the  identified gap. First, review the literature from the five articles in your chosen track (three that were provided for you and two

1. The basis for our lesson this week came from the Standards of Practice for Culturally Competent Nursing Care Executive Summary, Transcultural Nursing Society:https://www.tcns.org/standards (Links t Nursing Assignment Help

1. The basis for our lesson this week came from the Standards of Practice for Culturally Competent Nursing Care Executive Summary, Transcultural Nursing Society: (Links to an external site.). Assume your nursing leader has decided that the department needs to better incorporate these Standards of Practice for Culturally Competent Nursing

Instructions Review Chapter 6 in your text, The Aging Networks:

  Instructions Review Chapter 6 in your text, The Aging Networks: A Guide to Programs and Services; review the website Elder Justice; and in a journal assignment, address the following: What new or surprising information did you learn about elder justice? How is elder justice a policy issue? Do you

Include the following sections (detailed criteria listed below and in the grading rubric). Identification of the Selected Measure Identify the selected

Include the following sections (detailed criteria listed below and in the grading rubric). Identification of the Selected Measure Identify the selected performance measure. Analyze the selected measure for clinical significance and evidence base. Describe practical implications for practice. Provide support from at least one scholarly source. Implementation Planning Develop a

This assignment will challenge you to explore thoughts, feelings, and

This assignment will challenge you to explore thoughts, feelings, and reactions to topics introduced in this course. You will address a newly selected topic, different from the one selected before The assignment is an integrative assignment that supports synthesis and the three course learning outcomes: apply knowledge of cultural and

U.S. Department of Health & Human Services. (n.d). Using language

  U.S. Department of Health & Human Services. (n.d). Using language access services. Accessed from: https://thinkculturalhealth.hhs.gov/resources/videos/using-language-access-services Compare and contrast the range of medical language interpretation and describe what is considered “best practice.” Consider and describe at least two scenarios in which patients are non-English speaking and qualified language interpretation is

This is the culmination of your work in the first

This is the culmination of your work in the first year of the Healthcare Informatics program. You will each write an integrated, comprehensive, professional document detailing your complete plan for implementing a new EMR at your hospital that replaces an old one that was not successful. It will include your

For this assignment, you are required to create a video

For this assignment, you are required to create a video on the importance of water in the body. The video can be made using PowerPoint or PowToons or other video software and should be 3 minutes long.  Your video must have audio (prepare a script before recording) It should include

We would all agree that there is some level of

We would all agree that there is some level of stress in everyone’s life. The stress response may be quite similar for each of us; however, there are distinct differences in the way women and men experience and respond to stress. In your exploration of these concepts, respond to the

Interpersonal Process Recording (IPR) Purpose This assignment will help prepare

  Interpersonal Process Recording (IPR) Purpose This assignment will help prepare you for conversations with clients with a mental health condition. Course Competency Describe the foundations of mental health nursing. Transferable Skill Communication: Displaying capability in writing, reading, and oral communication; understanding of non-verbal language.   Instructions It will be

Describe a time when you were influenced by someone else

Describe a time when you were influenced by someone else to make a substantial change in your life (e.g., change jobs or address a habit, such as to stop smoking). Describe the change you were influenced to make, who influenced you, and the nature of the influence. Apply the ELM

Science of Scalable Sales Team

 About: Science of Sales (3% of the course score) Watch this video before taking the quiz GV Workshop: The science of building a scalable sales team https://www.youtube.com/watch?v=JHHmpujs3f4&feature=youtu.be GV Workshop: The science of building a scalable sales team Science of Sales Video: In the very beginning (minute 1) Mark Roberge refers

interview planning

Employment interviews can be very stressful – for you, the employer, as well as for the candidate. The chapter discusses proper interview planning to ensure that you obtain the content information you need to make a good selection. For your initial post: interview problem: sex/gender Questions about an applicant’s sex,

Political commercials and the effect

Political commercials and the effect  Paper details Today, many of the political commercials we see are paid for by special interest groups or political action committees. Using the Museum of the Moving Image – The Living Room Candidate (http://www.livingroomcandidate.org/commercials/type/backfire), review three different political commercials from the different categories (Backfire; Biographical;

TITLE : Digital marketing before and after pandemic Sections that

TITLE : Digital marketing before and after pandemic  Sections that will be included in the final report. Any report must have the following sections: Introduction. Discussion. Conclusion.  your report should include at least one more section that you find necessary. For each section, your report structure document should provide a