Tag: SPL code example

Some tables in a simplified supermarket inventory management system are as follows. Firstly, there is the commodity table Commodity.txt, which records information about various products: The following is the Stock.txt purchase record table. Supermarkets purchase goods at 5 am every day, and the table records the quantity of each product purchased each time: The following is the final inventory table for each month, Storage.txt, which records the remaining inventory of all products on the last day of each month: Finally, the detailed sales record table Sale.txt of the supermarket: To assess the suitability of the procurement strategy, it is necessary

Here is the employee information table for a certain company called Employees: Due to business reasons, the employees of this company have frequent regional transfers. To record the transfer history, they used the following table EmpTransfer, which records every job transfer of employees since joining the company (employees who have already resigned are not included in this table): The date and target location of each transfer are recorded in it. Now please identify employees who have accumulated more than 5 years of work experience in New York. The key to this problem is to transform the structure of the table

A certain company plans to provide affordable housing benefits to married employees within the company. This benefit is only available to families where both spouses are within the company, and one of the conditions is that the age of the couple is 70 years old or above. Here is the employee information table of the company: Employees： The following is the employee relationship table EmpRel, which records the relationship between two employees. A Relationship of Spouse indicates that they are husband and wife. The fields for Employee 1 and Employee 2 both contain employee IDs, and the relationship in this

The following is the daily closing price record StockRecords of a certain stock exchange within one month, where CODE column is the stock code, DT is the date, and CL is the closing price: Try to find stocks that have risen by 9.5% for three consecutive days this month. Sort the records by code and date, and then group them by stock code to obtain a price list for each stock over the past month. This makes it easy to calculate the daily rise and fall rate of each stock. By comparing the rise and fall rate with the standard

The following is the historical sales contract record table of a certain enterprise: Below is their client information table: Customers ranked by sales revenue within a certain year, and the top n customers who reach half of the sales revenue are called the “major customers” of that year. Please list the major customers of the company in 1998. Group the contract table by customer, calculate the total amount for each customer and sort them in descending order, then calculate half of the total sales value. Finally, scan the table and continuously accumulate sales until reaching half of the sales value.

A certain B2C website needs to calculate the shipping cost of an order. In most cases, the shipping cost is determined by the total weight of the package. However, when the price of the order exceeds $300, free shipping is provided. The detailed rules are shown in the mailCharge table below: This table records the postage for each field within various value ranges. For example, the first record indicates that when the COST field value is between 300 and 1000000, the postage is 0 (free shipping); The second record indicates that when the value of the WEIGHT field is between

After scanning the barcode, it is a 13-digit numerical string. To cope with scanning errors, barcodes have a “check and verify” method used to verify whether the barcode is correct. The specific calculation rules are: Extract the first 12 digits of a 13-digit string, add the odd digits to obtain S1, add the even digits to obtain S2, subtract S2 from S1, then get the remainder of division by 10, and finally take the absolute value. The resulting number should be equal to the 13th digit barcode. If they are not equal, it is an incorrect barcode. Please calculate the

Employees.txt is an employee table for a certain company, which records the ID and name of each employee: Relationships.txt records the subordinate relationships between employees. For example, the first record represents employee 7902, whose manager is employee 7566, and the 14th record represents employee 7839, who has no manager and is the top-level manager. Please return a result set that describes the hierarchical relationship of the entire table, with the following structural requirements: KingKing-BlakeKing-Blake-Allen…King-ClarkKing-Clark-Miller… Firstly, identify employee A and find their corresponding superior B through the relationship table. Then, search for B’s superior C and repeat the process. Until the

The 24 Point Game is a classic puzzle game played with playing cards. The rules of the game are as follows: Remove the Jokers from a deck of playing cards, leaving 52 cards, randomly draw 4 cards, and use the numbers on the cards (where J, Q, K, A represent 11, 12, 13, 1 respectively) in combination with addition, subtraction, multiplication, division, and parentheses to achieve a result of 24. Each card must be used once and only once. Write code to calculate 24 for any given four cards, outputting the solution in text format. A B C D 1