MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE `properties` (
  `id` int(11) AUTO_INCREMENT PRIMARY KEY NOT NULL,
  `name` varchar(255) DEFAULT NULL
) AUTO_INCREMENT=1
CREATE TABLE `property_plots` (
  `id` int(11) AUTO_INCREMENT PRIMARY KEY NOT NULL,
  `property_id` int(11) DEFAULT NULL,
  `no_sqyds` int(11) DEFAULT NULL, 
  FOREIGN KEY (`property_id`) REFERENCES `properties`(id)
) AUTO_INCREMENT=1
CREATE TABLE `orders` (
  `id` int(11) AUTO_INCREMENT PRIMARY KEY NOT NULL,
  `property_id` int(11) DEFAULT NULL,
  `plot_id` int(11) DEFAULT NULL,
  `no_sqyds` int(11) DEFAULT NULL, 
  FOREIGN KEY (`property_id`) REFERENCES `properties`(id), 
  FOREIGN KEY (`plot_id`) REFERENCES `property_plots`(id)
) AUTO_INCREMENT=1
INSERT INTO `properties` (`id`, `name`) VALUES
(1, 'Lake View Park');
INSERT INTO `property_plots` (`id`, `property_id`, `no_sqyds`) VALUES
(1, 1, 50),
(2, 1, 75),
(3, 1, 100);
INSERT INTO `orders` (`id`, `property_id`, `plot_id`, `no_sqyds`) VALUES
(1, 1, 1, 25),
(2, 1, 2, 50),
(3, 1, 1, 25),
(4, 1, 3, 50);
SELECT 
  property_id
, prop.name AS property_name
, (SUM(order_no_sqyds)/SUM(plot_no_sqyds))*100 AS percentage
, SUM(plot_no_sqyds) AS plot_no_sqyds
, SUM(order_no_sqyds) AS order_no_sqyds
, COUNT(plot_id) AS total_plots
, SUM(total_orders) AS total_orders
FROM
(
    SELECT 
      plot.property_id
    , plot.id AS plot_id
    , plot.no_sqyds AS plot_no_sqyds
    , SUM(ordr.no_sqyds) AS order_no_sqyds
    , COUNT(DISTINCT ordr.id) AS total_orders
    FROM property_plots AS plot
    LEFT JOIN orders AS ordr
      ON ordr.plot_id = plot.id
     AND ordr.property_id = plot.property_id
    GROUP BY 
      plot.property_id
    , plot.id
    , plot.no_sqyds
) q
INNER JOIN properties AS prop
   ON prop.id = q.property_id
GROUP BY property_id, prop.name
ORDER BY property_id


property_id
property_name
percentage
plot_no_sqyds
order_no_sqyds
total_plots
total_orders


1
Lake View Park
66.6667
225
150
3
4


SELECT 
  plot.property_id
, prop.name AS property_name
, (SUM(ordr.no_sqyds)/SUM(plot.no_sqyds))*100 AS percentage
, SUM(plot.no_sqyds) AS plot_no_sqyds
, SUM(ordr.no_sqyds) AS order_no_sqyds
, COUNT(DISTINCT plot.id) AS total_plots
, SUM(total_orders) AS total_orders
FROM property_plots AS plot
INNER JOIN properties AS prop
   ON prop.id = plot.property_id
LEFT JOIN (
  SELECT plot_id, property_id
   , SUM(no_sqyds) AS no_sqyds
   , COUNT(DISTINCT id) AS total_orders
   FROM orders
   GROUP BY plot_id, property_id
) AS ordr
  ON ordr.plot_id = plot.id
 AND ordr.property_id = plot.property_id
GROUP BY 
  plot.property_id
, prop.name


property_id
property_name
percentage
plot_no_sqyds
order_no_sqyds
total_plots
total_orders


1
Lake View Park
66.6667
225
150
3
4


    SELECT 
      plot.property_id
    , plot.id AS plot_id
    , (SUM(ordr.no_sqyds)/plot.no_sqyds)*100 AS percentage
    , plot.no_sqyds AS plot_no_sqyds
    , SUM(ordr.no_sqyds) AS order_no_sqyds
    , COUNT(DISTINCT ordr.id) AS total_orders
    FROM property_plots AS plot
    LEFT JOIN orders AS ordr
      ON ordr.plot_id = plot.id
     AND ordr.property_id = plot.property_id
    GROUP BY 
      plot.property_id
    , plot.id
    , plot.no_sqyds


property_id
plot_id
percentage
plot_no_sqyds
order_no_sqyds
total_orders


1
1
100.0000
50
50
2

1
2
66.6667
75
50
1

1
3
50.0000
100
50
1