Joins jobs

I need a skilled developer to create an automation bot for Telegram Channels. This bot will have the essential functions of: - Auto-joining channels - Extracting basic channel information including the description and links I want the bot to be able to extract the following specific information from the channels it joins: - Channel Name - Channel Description - Channel Links - Member Count The frequency of this extraction should be set to a weekly basis. Ideal skills and experience for this job would include proficiency in Python or a similar programming language, previous experience with Telegram's API, and prior experience creating chatbots or automation bots. Expertise in web scraping technologies is also a must.

I'm looking for an experienced SQL programmer who can assist me with data manipulation and querying on Microsoft SQL Server. The main tasks you will be responsible for are: - Writing and optimizing complex SQL queries - Implementing joins and subqueries - Developing stored procedures and functions The ideal candidate should have: - Proficient in Microsoft SQL Server - Experience in data manipulation and querying - Strong understanding of joins and subqueries - Ability to write and optimize SQL queries - Experience with stored procedures and functions. If you are confident in your SQL skills and have experience with Microsoft SQL Server, I would love to discuss this project with you.

...database schema to rectify some complex queries. My time is deeply invested in other areas of my project, hence the need for a reliable, efficient expert who can complete the tasks below: - Write complex SQL queries: The tasks will require you to navigate through my database schema, and based on the relationships and business rules, write complex queries. This will require a profound understanding of JOINs, subqueries, stored procedures, and other advanced SQL concepts. - Performance tuning of SQL queries: Your task is not just to make them work, but optimize these queries. This will include ensuring they run efficiently, making suitable indices, tuning any other aspects of query execution. Necessary skills include: - Strong experience in writing complex SQL Queries - Excell...

I have a number of JPEG images that contain SQL queries. I need these queries to be accurately typed and saved on a digital format for my convenience. To successfully complete this task, you should: - Be proficient with SQL, specifically with creating queries that include joins and sub-queries, as this is the complexity level of the queries you'll deal with. - Have keen attention to detail to ensure the queries are accurately translated from the photographs. - Be able to work without direct oversight as there are no specific naming or formatting conventions to follow. Please note that you do not need to execute these SQL queries, just type them out. Let's make database management easier, shall we?

...within a horror-themed environment. Key Responsibilities: - Develop engaging gameplay mechanics to enhance user interactions. - Craft user interfaces that are intuitive and seamless. - Script NPC behavior, ensuring captivating elements of surprise and intrigue. About the game - Infected style game with "infected" as one team, "humans" as the other, when an infected kills a human the human then joins infected team. -A functional shop with purchasable guns for human side (Assets will be provided) - Map vote rotation with game reset after so many minutes (if all humans die game resets) -2 Different classes for infected with each having a unique ability with cooldown, one having more heath other more speed - Possibly a leveling system with prestige, levelin...

Please Sign Up or Login to see details.

I'm seeking a professional kitchen fitter to cut and fit laminate worktop for a modern style kitchen in my home. The job will require experience in kitchen installation, and the candidate needs the correct routing and cutting equipment. There are two joins to be made.

...look at the query it doesnt seem excessive but something is slowing it down i need this looked at to see if we can come up with a way to speed it up. 0 blocked emails page loads in about 5 secs 300 blocked emails page takes over 1 minute to load My MySQL query, which joins multiple tables, is taking too long to run. Unfortunately, I can't share the data it's run against. - The problem: My query takes too long to execute. I need it to run faster without compromising the results. - Query complexity: It involves joins across several tables. An understanding of structuring multi-table queries for optimal performance is needed. - Note: I won't be able to provide a sample data set. However, I can explain the schema in detail. I'm looking for someon...

I'm looking for a skilled individual to create a thermal imaging 2D mosaic for temperature monitoring in urban landscapes. You will be tasked with: - Developing a system that can accurately monitor temperature variations across outdoor urban are...image; not an orthomosaicking process. The pixel values of the thermal data must not be changed, so there can be no colour-balancing, no image brightness scaling, stretching or similar. (The pixel values represent temperatures, so their integrity must be maintained.) The cut lines between the frames must follow natural features in the imagery as much as possible, so that the visibility of the joins between frames is minimized. The output must be the same projection as the base map (UTM). The GSD of the thermal mosai...

I need complete 2 small projects done. The data needs to be pulled from API using python. The pulled data needs to be unnested, then transformed to answer some insights with medallion architecture. Here, you need to showcase SCD-type 2 ingestions, incremental joins, managing PII information, aggregation. Final deliverable needed for 1st project (databricks): Data model designed and architecture overview Notebooks of transformations in Python and PySpark/Spark Scala Final deliverable needed for 2nd project (dbt): Data model designed and architecture overview dbt sql and yaml files

I'm currently in need of assistance with a MySQL query task; specifically how to make use of a subquery in order to yield accurate results in a Select statement. The main purpose here is to fetch data. **** All SQL files are attached to the files for this project. What I am Seeking: Help with the attached query. The query joins two tables. A header and details table. The intent of the subquery in this statement is to find/match a SINGLE "Invoice Date" value in the inv_details table that matches a "PO Date" from the po_details table in the subquery using the main queries currently matching "item" , "ship to city" and "customer name". Using "distinct" in the subquery generates an error (subquery returns more than on...

...like identifiers, values, and timestamps from several intricately related operational stores. It should then compile and organize the extracted segments to provide a holistic view of core business operations over a specified timeframe. The constituent pieces must be intelligently linked and cross-referenced to offer meaningful insights. The underlying database schema may be intricate with numerous joins and intricate relationships between entities. As such, the SQL development will require strong expertise in querying disparate sources and nesting clauses to obtain all needed attributes. Optimization will also be critical as improper queries could impact system performance. Overall, the finished report must deliver a cohesive narrative and present compiled information in a clear ...

...services. These include: - Photo retouching: This will involve modifying the lighting, contrasts, and color balances to produce a visually pleasing image. - Image resizing: You will be expected to resize various images without reducing their quality. - Accurate replicate overlays: One of the crucial components of this project is to replicate specific line overlays that indicate measurements and joins. This project isn't just about repurposing images. It's about enhancing them to serve their intended purpose. Therefore, the freelancer should have a keen eye for detail, display creativity and be able to meet set deadlines. I'd like to have this project completed within a month; hence, time management skills will be highly regarded. Please provide some examples of ...

I need someone familiar with PHP and oscommerce to help me customise my admin panel - i want to hide certain pages and links on the sidebar and edit some buttons and functionality on the page - some of the pages will require to create PHP rules or MYSQL JOINS/CONDITIONS to alter the content depending on who is logged in we will go thru each section of the sidebar one by one a fairly straightforward job if u know the system and PHP. video call essential to discuss milestone before agreeing price and awarding no time wasters no arrogant rude freelancers follow my rules be nice and work hard PLEASE NOTE: you will be working via my system - via screen sharing FTP is not possible for this task. We will only do the work in small chunks to allow you to complete it before moving on t...

...experience in building websites/templates with HTML5 or Vue.js • Proven ability to graphic design and build mobile first web sites. • Excellent attention to detail to capture the specific requirements of our website and provide feedback to improve if possible. Wireframes are attached. There could be half a dozen more pages to be built for the final product. I would like to pay by the hour as whoever joins the project will need to be engaged with us for ongoing work as we continue to build the functionality around the designs you will be providing. So when you post your bids consider this as a project that first version need to be built asap and continue to support us ongoing for a couple of months with ~10 hours per week. Join us in creating a smooth, attractive websi...

I need someone familiar with PHP and oscommerce to help me customise my admin panel - i want to hide certain pages and links on the sidebar and edit some buttons and functionality on the page - some of the pages will require to create PHP rules or MYSQL JOINS/CONDITIONS to alter the content depending on who is logged in we will go thru each section of the sidebar one by one a fairly straightforward job if u know the system and PHP. video call essential to discuss milestone before agreeing price and awarding no time wasters no arrogant rude freelancers follow my rules be nice and work hard thanks

Salut à tous, Je suis à la recherche d'un graphiste capable de créer une affiche A3 attrayante pour mon Bubble tea. Voici les détails : - Le design doit comprendre des photos. Vous pouvez vous servir de photos que vous avez dé...L’affiche sera affiché dans plusieurs établissement et commerce. Idéalement, le candidat doit avoir une expérience dans la création d'affiches et une compréhension du Bubble tea ou d'autres boissons similaires. Il est également préférable si vous avez des compétences en photographie afin de choisir les meilleures images possibles pour l'affiche. J'ai hâte de voir ce que vous pouvez créer ! Je vous joins : ...

We need help with our Spring Boot backend. We have 2 Entities defined: Client and Dossier. Each client can have multiple dossiers and each dossier can be assigned to one client. Client: ...fetched with their dossiers. But we don't want to fetch the dossiers by default. We also created a custom query @Query("SELECT c FROM Client c WHERE = :uuid"), but also the dossiers are fetched. It looks like is not working. We want to manage this behaviour, since we are building an application which handles a lot of data and a lot of JOINs. So: by default just fetch the client. If asked, fetch dossiers and other JOINs, like addresses and phone numbers. Database engine: we tried both MySQL and Postgres, but no result. We want to implement clean and less code in our ...

HI i have my backend admin called STORE MANAGER Once a STORE MANAGER logs in their STORES_ID is registered and the data and options on the screen will be connected to the STORES_ID i need all the mysql queries and joins updated to include the STORES_ID so only the correct data shows currently all data is showing i also need certain links and navigation links removed or hidden from sidebar when stores_id > 0. NO TIME WASTER ONGOING WORK FOR RIGHT CANDIDATE WILL NEED TO SPEAK TO ME ON A CALL AND VIDEO CONFERENCE SO I CAN SHOW U THE SYSTEM

i have a php script with some mysql queries and joins by DEFAULT there is no filter or condition on the STORE ID as when the script is loaded the first time no store id is selected so ALL data will be loaded for all stores now to filter the data for a specific store i added a WHERE clause to my query where o.orders_stores_id = '" . (int)$_GET['store_id_dd'] . "' '" . (int)$_GET['store_id_dd'] . "' is determined once i select a store from the dropdown filter. then it registers once i press submit however this only works if i add that WHERE clause the issue with that WHERE CLAUSE is that the DEFAULT or NULL case will not work and nothing will be returned as the code is treating it as NOTHING i.e its expecting a store id...

I have a PHP script which contains some mysql queries and joins and displays data on a web page. The data output can be fine tuned using filters in the script like date etc Basically I need my script enhanced to alter the data output I will tell u what I need or want. We may need to just make a new script and edit the code that way the original is not affected. I have several scripts needing enhanced. This is long term ongoing work so I need a coder highly skilled in php scripts and mysql queries/joins No amateurs or time wasters. A call will be good to show u the script in action and confirm Ur skills and if u can deliver what I need

...essence of this project revolves around retrieving data effectively, necessitating an adept handling of multiple table joins. **Key Requirements:** - Deep understanding of Oracle database systems. - Proven track record in writing complex SQL or PL/SQL queries. - Proficiency in creating queries for data retrieval aimed at reporting, with an emphasis on efficiency and accuracy. - Experience with complex joins involving multiple tables, ensuring seamless data integration and optimization. **Ideal Skills and Experience:** - Excellent knowledge of Oracle's advanced features and best practices. - Strong problem-solving skills to navigate the intricacies of multiple table joins. - Familiarity with performance optimization techniques for SQL queries, aimed at reduci...

...to 10 minutes in length. The main task involves basic cutting and joining sequences to make the videos smooth and engaging for my audience. I have more than 10 videos that need editing, requiring consistency and a quick turnaround time across the series. **Key Requirements:** - Proficient in video editing software (e.g., Adobe Premiere, Final Cut Pro) - Ability to perform basic cuts, trims, and joins without losing content quality - Capable of meeting tight deadlines while maintaining consistent quality across all videos - Good communication skills to understand and implement specific editing requests **Ideal Skills and Experience:** - Previous experience in editing YouTube videos or similar projects - A good eye for detail to ensure smooth transitions and seamless cuts - Effic...

..."ddd-sdgs-rewd" * When i call the join API endpoint, the bot should log in to the google account(this will be a special google account. credentials to this account should be provided via environment variables) and then join the call. There might be 2 cases(one is when the bot was already invited, then he doesn't need to "ask to join" and if he is not invited, then he should "ask to join"). After that bot joins the meeting and records video/audio files to AWS(credentials will be provided through environments) * When i call "Stop" endpoint, then bot should stop recording, save file and leave the call Some additional stuff * If the bot was kicked from the call, then we should stop recording, save the file **Ideal Skills and Experience:*...

I need to write an SQL script or PHP script to EXPORT MENU DATA from MySQL database The problem is data is coming from several tables so will require some JOINS in the query to produce the desired results. I will provide the full technical details of the Table Names Column Names and values once u place ur bid and we can discuss the job. I want the output as CSV (Excel is best) so that will have 4 columns of data i expect perfect work - no mistakes for this the data result must be 100% correct. i will check it after u do it

in my PHP file i have some MY SQL QUERIES and some JOINS i need to add in another JOIN (not sure if its left or right) there is one more data point from another table that needs to be considered in order to display meaningful data. URGENT JOB PLEASE HELP NO TIME WASTER

in my PHP file i have some MY SQL QUERIES and some JOINS i need to add in another JOIN (not sure if its left or right) there is one more data point from another table that needs to be considered in order to display meaningful data. URGENT JOB PLEASE HELP NO TIME WASTER

I need two separate contracts to be written. We have a small commercial cleaning company and wed like to have a standard contract to have every new client signed. I also need a second contract that I can have any new employee that joins our team. Something simple.

...SUR SAONE. J'habite dans la même ville, mais pas dans le même quartier. Alors je souhaite créer un panneau, comme ceux que les agences immobilières mettent lorsqu 'un appartement est vendu avec les dimensions 120 x 80 cm, et le fixer sur le portail de ma maison, pour que les passants me connaissent, sache que j'ai une agence immobilière et où elle se situe, pour qu'ils puissent me contacter. Je joins le logo de l'agence, la vitrophanie collée sur la vitrine de mon agence ( peut être pourrions nous garder et détourer ma photo ) l'adresse de l'agence est 52 avenue Boucicaut 71100 CHALON SUR SAONE téléphone mail et une phrase d'accroche : vous avez un projet immobil...

I need an SQL expert to modify an existing T-SQL stored procedure. The task primarily involves tweaking the query logic. To be specific, I'm looking for someone who can: - Insert and add more tables/joins to enhance the complexity and robustness of the existing procedure. - Modify some of the current conditions to align with business dynamics and needs. The ideal candidate should have extensive experience with T-SQL, and a good understanding of complex query logic and stored procedure optimization. Your experience with SQL server optimization will be a plus.

As a member of a team working with a specialized Postgres SQL database, I need someone proficient in SQL to conduct a walkthrough on writing complex queries, over a Zoom call. During the walkthrough, we'll be focusing deeply on: - Syntax and formatting - Managing associations using Joins - Writing Subqueries and nested queries My main aim is to understand the structure and formatting of these queries, how to establish relationships across various database entities using joins, and understand the use and function of sub-queries and nested queries. The functionalities of tables and fields in the queries are also a crucial part of this project. Ideal qualifications would be: - Extensive experience with SQL - Ability to explain complex SQL concepts clearly - Familiarity ...

As someone seeking assistance with my Oracle SQL project, my need is precise and task-oriented. I'm grapplin...and database design. The task involves sophisticated data handling, so someone with substantial Oracle SQL experience will be an asset. Proficiency in understanding and writing conditional SQL queries is essential. - Complexity: Considering the condition's complexity for this task, I'd say it is of moderate level since it's associated with multiple column values. Hence, someone who can juggle joins, subqueries, or more complex queries would be a great fit. In conclusion, I'm in search of someone to help update table content under specific conditions in an Oracle SQL database. It's not a task for beginners, rather for someone who doesn'...

I am seeking a skilled developer to create a report design module for use with Odoo v16 and Odoo v17 in the community version. This task will need someone with the following skills and experience: - Comprehensive understanding of Odoo V 14 v16 and v17 - Extensive experience with PostgreSQL and the ability to perform table joins with multiple models - Ability to implement real-time data representation The resultant design module should include: - A drag-and-drop interface for ease of use - Capability to generate real-time data representations Ultimately, this module will be used for "Report Designer". Therefore, a background in financial, sales and inventory reports creation could be beneficial, or any other industry-standard report creation. Please bid if you believe y...

...table, for faster access. The new table should be able to run a cron or something to get the new data daily into the new table. 2) This will ensure that 2 pages (predictions and betting) won't need to calculate or run long queries, but get the predictions direct from the new database table. 3) The profits page, will get information from both: - New Predictions Table - Results Table (with the joins) Please see logic of before and after. 4. Diagnosing and fixing the profit and loss calculations for race, event, and range that are currently malfunctioning. 5. Resolving the issue with filter odds, which is currently not performing as expected. This task will need a senior developer, already 6 developers have been unable to complete this task. I have a document with more...

...also get referral-based Income. There are three types of income: Referral Income Monthly Income Bonus Income Referral Income The user who is referring a new member will be paid one time (First-time bonus). Monthly Income This is another form of income that you can generate from our system apart from the Referral Income. Bonus Income: Bonus amount is paid to a user when the referral of the user joins another person in the group. The more number of referrals get associated in each link hand of the user, the more will be the bonus. The bonus is paid with the monthly payout of the user. Monthly Bonus: This bonus is paid after observing the monthly performance of the user. This bonus is paid along with the monthly payout of the user after checking through from 1st to 31st of ever...

Our new mobile game requires a quality physics engine for realistic car deformation. So we are looking for developer to create this tool so that we can easily continue developing the game. We are inspired by games like and Rigs of Rods. We have some initial developments such as (Nodes that are connected by joins and use verlet). But with discussion we can start from scratch. We will provide you with a unity project for development. We plan to use the Mass-spring-damper model to achieve the desired effects. Requirements: the ability to create efficient and optimised solutions for high performance. Deep understanding of the Mass-spring-damper model and its application in deformation. Quick to understand other people's code. If you have the necessary skills and experie...

I am looking for a freelancer who can assist me with an affiliate marketing project on Instagram. The goal is to refer more than...perspective beyond Photomath. With M.O, simply scan a solution and it instantly verifies each step, providing immediate feedback. Sign-Up at: Exciting Offer: You receives a 3-month premium subscription for free - just reply to this message! Our affiliate program also offers rewards for each sign-up through your referral. For every student or tutor who joins the free version of our app you'll earn $0.2 per signup. Discover the details and sign up at the ModusOperandi Affiliate Program: We eagerly anticipate your involvement in this exciting venture! Best regards, Guneet

We have an online meeting module in our application. The front-end is in ReactJS and it calls the meeting server link created in node.js using WebRTC. We have a system user that joins the meeting and records the meeting (streams from WebRTC). This functionality is developed in ReactJS where when we open an URL in browser, the system user automatically joins all the meetings in progress (1 tab for each meeting) This requires a browser to be open. We want this to run on a linux server, without opening a browser.

I am looking for a Node/React developer who can generate PDF exports based on an SQL database. The project requires custom styling and design for the PDFs. Skills and experience needed: Proficiency in Node.js and React - Strong knowledge of SQL databases and query optimisation - Experience with generating PDFs - Ability to handle multi-table joins in SQL queries for data retrieval The ideal candidate should have experience in designing and styling PDF exports, as well as expertise in retrieving specific information from a database and displaying it using line charts and pie charts. This report will need to have variations based on data within the database. Relevant information will be provided to the successful person. A basic interface will be provided that will provide date fi...

...especially focusing on captcha filling, payment levels, and a referral bonus system. The responsibilities of the project entail: - Designing an automated captcha generator. Your focus should include producing and validating completely random captcha. - Adjusting payments based on user levels. You will build a system where the user's level determines the payment rates. - Developing a system where new joins via direct referral will automatically get a 100 rupees bonus. Under admin features, we need a fully customizable system where we can tweak and monitor all project details efficiently. A successful candidate would have a broad understanding of PHP, experience in developing captcha systems and a keen understanding of referral systems. A developer who has previously built...

I require an advanced website developer to create a comprehensive college website. The purpose of this website joins to offer an informational platform for both prospective and current students. It is expected from the developer to include key features in the design, which comprise: • A well-structured course catalog for all available studies. • Comprehensive and easy-to-navigate admissions information. • An all-inclusive faculty directory, ensuring all staff members are adequately represented. • A dedicated space to provide information for NAAC, with the capability of uploading multiple documents. • News segment to keep the college community in the loop about recent updates. • Guest lecture section, so that users can access information about upcoming ...

...files via consistent identification markers. Data Storage and Segregation: - Allocation of AI-analyzed data into a separate storage segment for further processing. Statistical Analysis and Reporting: - Provision of statistical analysis on the aggregated data in the new segment. - Implementation of a system to dispatch each analyzed file back to its corresponding identifier-specific folder, where it joins pre-existing historical data. Historical Data Trend Analysis: - Feature to assess and report on historical trends and changes within each identifier-specific data segment over time. Skills and Experience: - Experience with Artificial Intelligence - Proficiency in Python programming language - Strong knowledge and experience in data analysis techniques and tools - Familiarity wi...

The task: To replicate the 52 variations of benchtop jpegs provided as the 9 new colours provided Background: We are a manufacturing company that makes custom benchtops for our customers. Customers have a number of choices when they design their benchtop: Benchtop shape: straight, L shaped U shaped Clashing: unjointed ends Positioning of joins: Left / Right / Multiple Breakfast bar: breakfast bar position. To help you understand it is worth working through our benchtop planner. Throughout the design process we use a dark benchtop silhouette. The last choice a customer makes is the benchtop colour. Once they make this decision we present a visual of the benchtop to them in the colour they have chosen. This visual reflects the choices they have made throughout the design proc...

I am looking for a freelancer who can complete some somewhat simple SQL queries for data analysis. The ideal candidate should have experience in MySQL and be comfortable working with intermediate queries involving JOINS and GROUP BY. This project requires the following skills and experience: - Strong proficiency in SQL - Experience with MySQL or Redshift SQL - Ability to write intermediate queries involving JOINS and GROUP BY If you have the necessary skills and experience, please submit your proposal.

I am looking for an experienced freelancer who can help write SQL queries with a user interface for a project I'm working on. The project requires working with a SQL Server database and writing intermediate SQL queries using joins, grouping, and aggregation. Additionally, the user interface needs to include both data entry and visualization functionalities. If you have the requisite experience with SQL and UI development, I invite you to submit a proposal and join me on this exciting endeavor.

I am seeking experienced affiliate marketers to promote home security systems through our affiliate marketing campaign targeting homeowners in the US. Target Audience: - Homeowners in the US Preferred Affiliate Platforms: - Both web and social media platforms Budget for the Campaign: - upto $100 per sale We are adding ten more products by next month like various internet service p...reports on campaign progress and performance If you have a proven track record in affiliate marketing and a deep understanding of the homeowners target audience's preferences and interests, we would love to hear from you. Join our team and help us drive sales and success in promoting home security systems to homeowners. You will be paid for every sale generated for all the products once a customer ...

I am looking for a skilled and experienced individual or team to create a cycling route that will join all 32 counties in Ireland. Roads used must be public, well surfaced, and suitable for a conventional road bicycle. It must cover as few kilometres as is reasonably possible. The proje...team to create a cycling route that will join all 32 counties in Ireland. Roads used must be public, well surfaced, and suitable for a conventional road bicycle. It must cover as few kilometres as is reasonably possible. The project should be completed in less than 1 month. Ideal skills and experience: - Some knowledge of cycling routes in Ireland - Ability to map out a long-distance route that joins all 32 counties - Efficient project management skills to complete the project within the specified...

Seeking experienced affiliate marketers to promote home security systems through our affiliate marketing campaign targeting homeowners in US. We are adding ten more products by next month like various internet service providers, fiber optic internet, Solar panels installation services and other brands targeting home owners. You will be a part of our network once you are associated wi...reports on campaign progress and performance If you have a proven track record in affiliate marketing and a deep understanding of the homeowners target audience's preferences and interests, we would love to hear from you. Join our team and help us drive sales and success in promoting home security systems to homeowners. You will be paid for every sale generated for all the products once a customer ...

...passengers.. 30,000 hopefully will take our glass elevator to the depths of 30 feet. A walk through tour and take the adjacent glass elevator out. There are two end to end elevators. I would like to show 3 illustrations. The pier view of the two end to end Underwater Hotels. Show the underwater hotel floating and show submerged with only the 14 foot wide... same width of the long Concourse that joins the 12 guest rooms. OK... Here's the delima. A previous online freelance basically initiated corporate sabotage. After 3 attempts no Fiverr had the qualifications. This unveiling is historic. I feel the TIME FACTOR is expired and no illustrations will be unveiled. Quite an embarrassing situation. I have faith this freelance group will do a fabulous job. I am lookin...

I need to learn about these topics. Ususally I m using MS Access for design. Please check my previous work but stuck at data normalization. Task 1: Data Normalization Convert each of your relations schemas / tables to 3NF, showing all int...should include these if/when possible: • Conditions using various operators on numbers, text and date columns with results sorted • Conditions applied to more than one column (AND/OR in the WHERE clause) • Arithmetic calculations and concatenated columns • Column aliases where required • Aggregate functions. (SUM, AVG, MIN, MAX, COUNT etc.) • Queries displaying results from more than one table (joins) • Queries including GROUP BY and HAVING Task 3: Views / Reports At least three useful and well designed data ...