C. Assume that a bookstore has 3 tables on their database, each table on author, book, and book sales, with samples of the data and columns as shown below. Please write an SQL query for each of the following problems. Turn in all the code that you write, and clearly state any assumption that you make (if any). Table 1: author \begin{tabular}{|r|l|r|} \hline id & author & birthaxear \\ \hline 1 & Jane Austen & 1900 \\ \hline 2 & Emily Bronte & 1901 \\ \hline 3 & Charlotte Bronte & 1902 \\ \hline 4 & Sylvia Plath & 1903 \\ \hline \end{tabular} Table 2: book \begin{tabular}{|r|l|r|r|} \hline id & title & publishingarear & authrsid \\ \hline 1 & The Bell Jar & 1980 & 4 \\ \hline 2 & Wuthering Heights & 1950 & 2 \\ \hline 3 & Pride and Prejudice & 1952 & 1 \\ \hline 4 & Jane Eyre & 1925 & 3 \\ \hline 5 & Persuasion & 1954 & 1 \\ \hline \end{tabular} Table 3: sales \begin{tabular}{|r|r|r|r|} \hline \multicolumn{1}{|c|}{ id } & sales date & book id & sales rrice \\ \hline 1 & $12 / 12 / 2019$ & 1 & 9.99 \\ \hline 2 & $12 / 12 / 2019$ & 2 & 7.99 \\ \hline 3 & $12 / 13 / 2019$ & 1 & 9.99 \\ \hline 4 & $12 / 14 / 2019$ & 1 & 9.99 \\ \hline 5 & $12 / 15 / 2019$ & 4 & 8.99 \\ \hline \end{tabular} 1. a. Find the highest and lowest selling books (that had at least one sale) by quantity during the month of Dec 2019. b. Find the highest and lowest selling books (that had at least one sale) by revenue during the month of Dec 2019. If there are multiple possible books with the same quantity or revenue, sort by author ID and then by publishing year 2. Find the top 3 highest selling authors by quantity from the year with the highest sales revenue, along with these authors' total sales revenue and sales quantity for that year 3. a. Find the oldest published book that the bookstore has. If more than one, share the full list. b. Find the sales price for its most recent sale 4. Find how old would the author be when each book was published 5. If we were to have 1 table on sales that would have all the data from all 3 tables combined,

Design a 4-bit UP-DOWN counter. It counts 1 to 7 only. The middle output is 1111. Include truth table, K-map with equation, and decoder implementation. Please answer fast 20 mins left

Complete MS Project Exercise 2 on Appendix A: Brief Guide to Microsoft Project Professional 2016 2. Continue performing the steps in this appendix, starting with the section called Developing the Schedule. Print out the following screens or send them to your instructor, as directed: a. Figure A-32. All task durations and recurring task entered b. Figure A-39. Network diagram view c. Figure A-46. Changing Work hours for tasks d. Figure A-56. Earned value report e. Continue performing the steps, or at least read them. Write a one-to-two page paper describing the capabilities of Project Professional 2016 and your opinion of this software. What do you like and dislike about it?

Please DO NOT respond to this question by copy/pasting the code provided elsewhere on the site, none of those work. Thanks. Virtual Memory Lab This lab project addresses the implementation of page-replacement algorithms in a demand-paging system. Each process in a demand-paging system has a page table that contains a list of entries. For each logical page of the process, there is an entry in the table that indicates if the page is in memory. If the page is in memory, the memory frame number that page is resident in is indicated. Also, for each page, the time at which the page has arrived in memory, the time at which it has been last referenced, and the number of times the page has been referenced since the page arrived in memory are maintained. The page table data structure is a simple array of page-table entries (PTEs). Each PTE contains five fields as defined below: struct PTE { int is_valid; int frame_number; int arrival_timestamp; int last_access_timestamp; int reference_count; } Each process in the system has a page table that is simply an array of PTEs. Each process also has a pool of frames that is allocated. The frame pool for a process is represented as an array of integers, where each Integer represents the frame number of a frame that is free and is available for use by the process. Note that in order to get the frame number in the pool, you first need to access the integer in the array. This lab project aims to exercise the various policies for page replacement. In particular, we study the following three page-replacement policies: First-In-First-Out (FIFO) Least-Recently-Used (LRU) Least-Frequently-Used (LFU) In order to implement the above policies, we need to develop corresponding functions that process page accesses for a process. That is, for each process, given its page table, a logical page number being referenced and the free frame pool of the process, the functions should determine the memory frame number for the logical page. Also, the functions should modify the page table and the free frame pool appropriately. The details of the functions with respect to the different policies are described below. You need to develop code for these functions that implement the specifications. Place the code in a file called virtual.c. You should include the oslabs.h file.

7-Eleven Malaysia Holding Berhad's annual report for the fiscal year ending 2021 is available at https://www.7eleven.com.my/financial-reports. (At least two years of comparable financial statements are required.) a) Assess 7-Eleven’s financial position for year 2020 and 2021 according to i) liquidity position, and how the liquidity position has changed over time from 2020 to 2021. (6 marks) ii) asset management position, and how its asset management efficiency has changed over time. (6 marks) iii) debt management position, and how its debt management has changed over time. (6 marks) iv) profitability ratios, and how its profitability position has changed over time. (6 marks) v) market value ratios, and how its valuation has changed over time. (6 marks) b) Calculate 7-Eleven’s ROE as well as the industry average ROE, using the DuPont equation. From this analysis, how does 7-Eleven’s financial position. (10 marks) c) Write your opinion on what you think would happen to its ratios if the company initiated cost-cutting measures that allowed it to hold lower levels of inventory and substantially decreased the cost of goods sold. No calculations are necessary. Think about which ratios would be affected by changes in these two accounts. (10 marks)

Globalization has created many opportunities for organizations. There are many advantages and ways to create value through outsourcing portions of one's global supply chain. For each opportunity, there are also many ways for the project to run into problems. In your initial post, address the following: Identify one example of an organization that created value for itself through outsourcing part of its supply chain. Provide a link to one resource. Identify the benefit that occurred. How did this benefit help the organization create value? Who was the value created for—the organization, or the customer? In your replies to at least two peers, discuss potential risks of outsourcing for the examples they provided—for example, risks to supplier quality or stability, intellectual property, or reputation. The following questions may help develop your responses: Can you provide an example of an organization that started outsourcing the supply chain and then stopped? What risks did the organization face that caused them to stop the project? Can you provide an example of an organization that outsourced similarly and faced reputational damage due to the project?

Research and write about Cloud and compare two cloud providers Popular Cloud providers are - 1. Google - GCP (Google Cloud Platform) 2. Amazon - AWS (Amazon Web Services) 3. Microsoft - Azure you can take any 2 from the above 3 ad compare